Forum Discussion
GRFid
Aug 15, 2020Copper Contributor
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 ...
SergeiBaklan
Aug 15, 2020Diamond Contributor
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
GRFid
Aug 16, 2020Copper Contributor
Thanks for the reply - I did finally figure this out - one has to go to the format section once the row has been highlighted and then you can delete the whole line etc. Thanks for your help.SergeiBaklan
- SergeiBaklanAug 19, 2020Diamond Contributor
GRFid , you are welcome