hide original cells after creating chart
 

I'm new to creating charts in Excel, but I can't figure out how to do
this...

After I create a chart from a range of cells, can I hide the original
cells that contain the source data ?

I only want to see the chart on the worksheet ....

Thanks for any help !


--
tcurrier
------------------------------------------------------------------------
tcurrier's Profile: http://www.excelforum.com/member.php...o&userid=31279
View this thread: http://www.excelforum.com/showthread...hreadid=511413

hide original cells after creating chart
 

Hi,

You can hide the cells but you will have to uncheck the 'Plot visible
cells only'. Select the chart and use the menu Tools Options. On the
chart tab is the 'plot visible cells' option.

Cheers
Andy

tcurrier wrote:
I'm new to creating charts in Excel, but I can't figure out how to do
this...

After I create a chart from a range of cells, can I hide the original
cells that contain the source data ?

I only want to see the chart on the worksheet ....

Thanks for any help !



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

hide original cells after creating chart
 

Exactly the info I was looking for
Great stuff


--
Jufa
------------------------------------------------------------------------
Jufa's Profile: http://www.excelforum.com/member.php...o&userid=30742
View this thread: http://www.excelforum.com/showthread...hreadid=511413