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, us...
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.