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 to G10 for not to data in chart. But here Jan month data showing in Dec-22 in chart.
For rest categories I want to show data from Dec-22 to Dec-23.
Please suggest how to achieve this.
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.
