Forum Discussion
How to remove a bar from a bar chart
This is simple - I have a bar chart with 4 rows and 2 columns with a legend - I want to remove one of the rows - when I do this in the data sheet, the bars gets deleted but there is blank space left ...
If you have something like this
and remove entire row 5, chart will be correctly redesigned
But if you remove not the row but data in this row, chart shows empty cells - you didn't change the range on which chart is built