Forum Discussion
Excel Chart not showing range correctly
Hi All, In attached sheet I have created a chart where for Total cost I want to show from date range Jan-23 to May-23 for that I have changes the Total Cost range in Chart range from column C10 t...
All series use the same x-values B4:N4.
Since you changed the y-values range for Total Cost to C10:N10, there is a mismatch between x-values and y-values.
As a workaround, set the value range of Total Cost to the original =Sheet1!$B$10:$N$10, and clear B10 so that the series skips that point.