Hi guys,
I created a chart from a data range that I wish to hide, the problem is that the chart goes hidden also!!!! :/
Does anyone know how to get around this issue? I know it can be done
Any tips please!
Hi guys,
I created a chart from a data range that I wish to hide, the problem is that the chart goes hidden also!!!! :/
Does anyone know how to get around this issue? I know it can be done
Any tips please!
1) Right click the chart and chose "Select Data".
2) Click on "Hidden and Empty Cells".
3) Put a tick next to "Show data in hidden rows and columns".
4) Click "OK".
BSB
Super....!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks