If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|