Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating links to cells with no content, but that have formatting | Excel Discussion (Misc queries) | |||
Creating a conditional format for a cell based on another cell's v | Excel Discussion (Misc queries) | |||
Creating a High-Low-Close chart with multiple series? | Excel Discussion (Misc queries) | |||
Eliminate creating list that returns blank cells | Excel Worksheet Functions | |||
3 cells are named - how to refere to them in one reference field in a chart | Charts and Charting in Excel |