Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I disable automatic chart creation in Excel?
When using the insert chart buttons, specifically XY scatter, Excel
automatically plots my entire dataset. I do not want this to happen with large datasets b/c I need to manually delete all the entires. Is there a way to prevent excel from automatically plotting the entire data set and instead let me define the plot manually? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I disable automatic chart creation in Excel?
To get a chart with no data at all, select an empty cell that also has
no adjacent cells that contain data. To get a chart with a limited subset, select the cells you want in the chart before creating the chart. On Thu, 12 Nov 2009 14:54:01 -0800, Huang wrote: When using the insert chart buttons, specifically XY scatter, Excel automatically plots my entire dataset. I do not want this to happen with large datasets b/c I need to manually delete all the entires. Is there a way to prevent excel from automatically plotting the entire data set and instead let me define the plot manually? Thanks Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - disable automatic function | Excel Worksheet Functions | |||
Excel - disable automatic function | Excel Worksheet Functions | |||
How to disable the automatic getpivotdata function in excel? | Excel Worksheet Functions | |||
How to disable the automatic getpivotdata function in excel? | Excel Worksheet Functions | |||
Disable the automatic reviewing toolbar in Excel | Excel Discussion (Misc queries) |