pivot chart add a ligne not in the pivot table

  • Thread starter Thread starter ludovic
  • Start date Start date
L

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
 
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.
 
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/
_______
 
Back
Top