Source data for a chart

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Source data for a chart

Post by BittenApple »

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

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Source data for a chart

Post by HansV »

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

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Source data for a chart

Post by BittenApple »

Hello Hans,
Thanks for this.
Respectfully,
Bita