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