Hi guys,
The attached excel sheet explains everything
Basically, My chart has 4 data series. two of them I wanted to show in the chart itself only (the percentages), and the other two I wanted to only show in the data table below the chart (I was able to hide them in the chart by not filling them with a color)
Now I want to hide the percentage series from appearing in the bellow data table. the first percentage is fixed to 5% so there is no need to show it, the second one it already show in the chart in a small box.
I looked online and could not find a solution, so I had to ask
Bookmarks