Forum Discussion
Chart Changed
I have an Excel Spreadsheet I have been using for several years. Today, one of the tabs is no longer formated like it should be. It is not displaying the color Key and the lines of my chart, save o...
Quick Fix…
- Right-click the vertical numbers (Y-axis) → Format Axis → under Bounds, change Minimum and Maximum from Auto to fixed numbers that fit your data. Check the right-side secondary Y-axis too if it exists.
- Click the chart's inner grid area (Plot Area) and drag its corner handles outward—sometimes it shrinks to a tiny box.
- For the thin lines: Click a line → Ctrl+1 → Line Width → set to 1.5 pt.
- For the legend: Click the + icon next to the chart and re-check Legend.
If none work, do this: Copy a working chart from another tab, paste it onto the broken tab, then right-click it → Select Data and point it to this tab's data. This instantly resets any hidden corruption without rebuilding from scratch.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.