Forum Discussion
chart change
I have an excel spreadsheet with several tabs. 4 of those tabs have charts. On my first chart, the information is no longer displaying correctly. I have deleted and readded, compared formating, used google. I cannot figure out why it is different. Only one of my chart lines is showing, the rest are so small I can barely see them and the heading color key won't display.
- If I post this twice, apologies, I backed out accidentally
1 Reply
Hi, when one chart suddenly shows only one visible line, I would first check the series source range and the vertical axis scale. Sometimes Excel keeps the chart but the source range shifts, or one value becomes much larger than the rest and compresses the other lines. Right-click the chart, choose Select Data, and compare each series range with a working chart. Also check whether the chart is using a secondary axis.
