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 one, are so small you can barely tell they are there. I cannot figure out what happened or how to fix it. Every other tab is how it should be. I'm not sure how to attach a screenshot here. I have deleted and readded. Same result. I have checked a previous document and compared formatting.
4 Replies
Seems it was caused by Excel losing or resetting chart element formatting (legend, line weight, or color key) on that specific worksheet tab., support.microsoft.com/en-us/office/excelexp/show-or-hide-a-chart-legend-or-data-table, support.microsoft.com/en-us/excel/add-a-legend-to-a-chart, support.microsoft.com/en-us/office/format-elements-of-a-chart
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.
Hi AShell23, when a chart suddenly looks compressed like that, I’d check the chart’s selected data range and axis scale before rebuilding it. One odd value, hidden row, changed named range, or automatic axis setting can make the legend and lines look wrong even though the chart formatting appears unchanged.
This was indeed my issue. I had all but one as numbers instead of dollars. Not sure how that happened!
