Does anyone Know what data is connected to this dashboard chart in the project management template.
I have struggled figuring out what data on the sheet makes up the chart as I have tried to highlight different columns and go back through and edit the connected data source, but nothing changes. I need to understand where the Remaining and Complete % are coming from. Thanks for the help!
Best Answer
-
It is most likely coming from somewhere in the top of the sheet. Are you able to provide a screenshot of the data above your current screenshot?
Answers
-
It is most likely coming from somewhere in the top of the sheet. Are you able to provide a screenshot of the data above your current screenshot?
-
It looks like it's the Details and Working Days Remaining columns that are making up the chart.
-
Yes I can, here below is a screenshot of all the information above what I sent earlier. As you can see nothing is being highlighted or selected. Let me know if you need anymore information as well.
-
Use a CTRL+F on the entire sheet to search for 56%. Try to find somewhere that it is in the same row as 44%. Double check in hidden columns and collapsed parent rows too.
In the chart itself... What columns are listed if you click on the dropdown where it says "All columns"? That may help you narrow it down as well.
-
All columns is the option, but if you deselect that and select the Details and Working Days Remaining columns, the same data will populate.
-
Ok. If you check across those two columns and find a row where 56% and 44% are on the same row then you should locate the cells being referenced for the chart.
Is there a particular reason you are trying to figure out where the source data is, or is it just out of curiosity?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives