Dynamically Growing Bar Chart

[Former Member]

Can a bar chart grow dynamically?

I have a report that can have hundreds of items on its bar chart. I made the chart horizontal so they would presumably all show. Crystal displays it in the amount of space I have given it and only displays the text for as many items at it thinkks it can fit comfortably

So I get a chart that looks like

Item 1 |----

---

|----

Item 13 |---

|---

Item 37 |---

_____________________________________________________________________________________

I would like to have a chart that would display the text of all of the items and grow down the page so if I happen to have 128 items the chart will be a lot longer than it will be if I have 30 items.

Is this possible?

Thanks,

Dick

[Former Member · Accepted solution]

Hi, if you have a lot of items to display, then you should think about using the table instead of charts.

to use the chart, you can make you page landscape view, and choose the largest page size, the chart can't grow automatically, it is a tool limitation.

Thx, Hao

[Former Member]

hi Dick,

Right Click the Chart,

Format Chart -> Can Grow (Option is Grayed out/Disabled)

From the above, Chart can't grow dynamically based on data in CR.

If you want all labels to appear,

Chart Expert -> Axes ->Number of Divisions -> manual :1

But when data is more, these labels appear very smaller.

Also, you can fix the size of chart based on estimated data before hand.

Regards,

Vamsee