Hello team,
I inserted a chart on a data. When I hide the data source for the chart, chart goes a way. Is there a way to go around this?
Respectfully,
Bita
Source data for a chart
-
- Administrator
- Posts: 78487
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Source data for a chart
Instead of hiding the range with the source data, move the source data to a different sheet, and hide that sheet. This won't affect the chart.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Source data for a chart
Hello Hans,
Thanks for this.
Respectfully,
Bita
Thanks for this.
Respectfully,
Bita