Bar Chart is not scaling to include all data
I have a bar chart with 4 data points: 71, 3, 0, 2. The vertical axis is scaling 0 - 3.5, so it only fits the smaller numbers and it has no bar for the 71. It prints the number 71 under the horizontal axis labels, under the number 0. How can I get the vertical axis to scale correctly (0-71+) and include a bar for the 71? The column label for the 71 is not included in the legend either. The legend should say "In Progress", "At Risk", "Unable to Make Date", "Date Not Yet Set".
Answers
-
I attached the bar chart above in the first image and the selected source data with column headings in the second image.
-
Hi Susan. I recreated your sheet/chart and it's doing the same for me when I direct it to the Sheet. However, when I created a report from the sheet it displayed just fine.
From Sheet:
From Report:
-
Thanks very much, @Mike TV . I was able to create a report to do this and it worked. Somehow, while editing the chart, it started behaving the same way even with the report data. I deleted the chart in my dashboard, saved it, opened it and added a new chart that again worked. I think someone at SmartSheet needs to look at why it doesn't work from a worksheet, but I'm happy to have a workaround!
-
Hi Genevieve. Do you have any input on why charts built from sheets do not display in the same way as charts from reports? I tried looking for info on that but didn't find anything.
-
Thanks for the tag!
Yes, so when you select a specific cell range in a Sheet, the Chart thinks you want the first column to be the Labels and the other columns to be the values. It auto-selects this checkmark:
If you un-check this, you'll see your first column appear as a bar in the chart, instead:
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives