Hello,

How can i add an item to an allready existing graph in excel?
the item must be added automaticly when i type another value in the table
witch my graph is based on.
if there are for example 5 items added in the graph you can't reserve space
in the graph for a possible sixth.
Can someone help me with this problem?

Thank you
Bern

Have a look at Jon's site for dynamic charts.
http://www.geocities.com/jonpeltier/Excel/index.html


--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Bern Holvoet" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> How can i add an item to an allready existing graph in excel?
> the item must be added automaticly when i type another value in the table
> witch my graph is based on.
> if there are for example 5 items added in the graph you can't reserve
space
> in the graph for a possible sixth.
> Can someone help me with this problem?
>
> Thank you
> Bern
>
>
>

If you want to extend the number of points in an existing series see
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

If you want to add additional series to an existing chart, it cannot be
done automatically -- at least not without VBA support.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004

In article <(E-Mail Removed)>, (E-Mail Removed)
says...
> Hello,
>
> How can i add an item to an allready existing graph in excel?
> the item must be added automaticly when i type another value in the table
> witch my graph is based on.
> if there are for example 5 items added in the graph you can't reserve space
> in the graph for a possible sixth.
> Can someone help me with this problem?
>
> Thank you
> Bern
>
>
>
>