pivot chart add a ligne not in the pivot table

[ludovic]

hello, I've a pivot table and the related graph and I
would like to add 2 ligne who represents the minimun and
maximum value before alarm.
I would like to knwo how to create 2 ligne in a chart by
vba
Thanks

 

[Debra Dalgleish]

You can create a normal chart, based on the pivot table, and include the
additional lines in that.

On Jon Peltier's site, there are instructions for creating a normal
chart from pivot data:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm

And for adding lines to a chart:

http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine

To create the code, you could record the steps as you do them.

 

[ludovic]

Ok, but how can I modify the chart range automatically when a new data are
inserted in the pivot table (thru query and ODBC), this is a graph by date so
every day a new column appear in the pivot table, but using the Jon Peltier's
it not update, and this graph have to be update without the intervention of
the users.
If you can help me thanks.

 

[Jon Peltier]

You could define dynamic range names that determine the size of the pivot table;
better yet, you can write some VBA to measure its size and change each series (and
add some if the table grows in both directions).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______