Charts not matching numbers
I have multiple semi-circle pie charts on a smartsheet dashboard but the chart is not matching the number. See below for example. The amounts show that funding is about 50% to goal…but the pie chart is not showing that percentage in graphic or in %. How do I fix this?
Answers
-
I know this is the Smartsheet equivalent of shut up and reboot, but have you checked the link for the chart to ensure it's point to the correct data? I've seen instances where I thought I was pointing to the correct cells and somehow that range got messed up. If you click edit on the widget you can edit the data and see where it's pointing, particularly when I have multiple sheets where this type of data has been summarized.
If the pointer to the source data is correct and the widget is still incorrect, I'd open a help ticket.
Hudson
-
Hi @alex.winter
I believe what the pie chart is doing with your data is that its taking the two values and plotting them independently (and summing them) as opposed to relationally so that Total Funding is a % of the chapter goal (which is what you are expecting). For this reason, the total value is ~3M and as a %, 1M (gray) is 33% of 3m.
I am not sure how you have the data structured in the data source, but having that relationship established in the data should help resolve this
