How do I disable automatic chart creation in Excel?

[Huang]

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

 

[Tushar Mehta]

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.

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