Prev: Pie Chart with automatic "All Other" group
Next: Balance Points in Excel Charts
From: Huang on 12 Nov 2009 17:54
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
From: Tushar Mehta on 12 Nov 2009 18:02
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
<Huang(a)discussions.microsoft.com> 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
 | 
Pages: 1
Prev: Pie Chart with automatic "All Other" group
Next: Balance Points in Excel Charts