ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Hiding source cell data after creating chart (https://www.excelbanter.com/charts-charting-excel/71114-hiding-source-cell-data-after-creating-chart.html)

tcurrier

Hiding source cell data 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=511414


Jon Peltier

Hiding source cell data after creating chart
 
You could create the chart as a chart sheet, or embed it on a different
sheet. It's on step 4 of the chart wizard, or available in the Location
command on the Chart menu.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"tcurrier" wrote in
message ...

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=511414





All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com