Dashboard

adelmans

Is there a maximum number of rows on the X or Y axis for a bar graph that can be shown on a Dashboard?

Samuel Mueller

@adelmans If you are using a report to create the chart, it's 500 rows. I think that is the only limitation.

Are you running into an issue?

Paul Newcome

Aside from the report limitation, the only other limitation is the widget can only be made so large before things start to get cramped.

There are a few solutions to this depending on your exact needs, but we would definitely need more details and screenshots to be able to assist.

For example: I have multiple charts that have 365 data points on the horizontal axis. To be able to read it, I had to limit which points were actually labeled.

adelmans

I am using a sheet to pull the rows and just need to ensure that the chart's key won't run into issues if it goes over 300 rows.

Paul Newcome

Are you able to provide some screenshots for context?

adelmans

This is the only screenshot I am able to provide. This chart is generated through a sheet, not a report. I just need to understand the maximum amount of rows that will be able to be visible on this chart.

Samuel Mueller

May not be super helpful, but if I were you, I would just populate 5 or 6 hundred rows of nonsense data and see what happens. Like Paul said, it's going to get very crowded.

Paul Newcome

Yeah. Your best bet is to put in a bunch of sample data and test it with widget sizes and whatnot.

Another option (still presents sizing challenges but allows you to remove the legend) is to switch what is shown on the chart vs the legend. Everyone would have the same color bar, but it will allow you to remove the legend entirely to present more data on the chart.

adelmans

Thank you!