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
2 Replies
Hello AShell23,
Since the other charts are working and only this one is affected, I will compare this chart with one of the working charts.
A few things to check:
- Right-click the chart and select Select Data to confirm each series is pointing to the correct range.
- Check the vertical axis (Format Axis) to see if the minimum or maximum bounds have been set manually. A single large value can make the other series appear almost flat.
- Check whether one of the series is plotted on a secondary axis.
- If the legend (color key) is missing, select the chart, go to Chart Design > Add Chart Element > Legend, and make sure it's enabled.
- Check whether any series have been formatted with No line or a line color that blends into the background.
If none of those resolve it, could you share the following?
- The chart type (Line, Scatter, etc.).
- A screenshot of the chart and a sample of the source data (with any sensitive information removed).
That should help identify the cause
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.
