Aug 15 2020 08:37 AM
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 and I can't get rid of the space.
Aug 15 2020 10:16 AM
Hello,
first here some Infos:
Change the display of chart axes
...and here are the instructions
Add, change, or remove error bars in a chart
I would be happy to know if I could help.
If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)
Aug 15 2020 12:36 PM
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
Aug 16 2020 09:18 AM
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.@Sergei Baklan