Missing data issue on a chart
Bredine
-
ccm81 Posted messages 11033 Status Membre -
ccm81 Posted messages 11033 Status Membre -
Hello everyone!
So, I have an issue with Excel... I'm making charts with Excel 2010 (Windows 7 Pro). However, on these charts, the data prior to 2008 doesn't show up!
I know how to create charts, so I checked the data selection, and it’s all selected correctly, perfectly. However, it counts as 0! It's a big mystery for me, I admit...
Everything from after 2008 displays, everything before just disappears!
HELP ME PLEASE!
Thank you all.
So, I have an issue with Excel... I'm making charts with Excel 2010 (Windows 7 Pro). However, on these charts, the data prior to 2008 doesn't show up!
I know how to create charts, so I checked the data selection, and it’s all selected correctly, perfectly. However, it counts as 0! It's a big mystery for me, I admit...
Everything from after 2008 displays, everything before just disappears!
HELP ME PLEASE!
Thank you all.
5 réponses
Hello,
Have you hidden the data prior to 2008 in your file?
If so, it's normal that they don't appear in your chart, even if they have been selected, because by default, hidden cells do not show up.
To resolve this, you need to go to:
Chart Tools > Design > Data > Select Data > Hidden and Empty Cells > Show data in hidden rows and columns
There you go, that might be your case; if not, it could help other users!
Best regards
Have you hidden the data prior to 2008 in your file?
If so, it's normal that they don't appear in your chart, even if they have been selected, because by default, hidden cells do not show up.
To resolve this, you need to go to:
Chart Tools > Design > Data > Select Data > Hidden and Empty Cells > Show data in hidden rows and columns
There you go, that might be your case; if not, it could help other users!
Best regards
Thanks anyway!