Create separate chart for each row in excel

[Guest]

I am attempting to create a separate chart for each row of my worksheet
(about 300 rows = 300 separate charts). Is there an easy way to do this?
The actual data range will change month-to-month, so I would not want to
have to recreate 300 new charts each month individually.

 

[Tushar Mehta]

While I have never created (or tried to create) 300 charts in a single
workbook, it is easy to believe that performance and stability of Excel
might become a question.

Do you have to have 300 charts? Or will one chart (or a few) that can
be easily changed to reflect new data suffice? If so, adapt the ideas
behind
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
specifically, the examples in 4 through 6.

--
Regards,

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

 

[Guest]

We are using one data source to create individual performance charts for each
of our customers. So yes, we need individual charts. The data is updated
(shifted) each month, so going through 300 rows to create a new chart is not
practical.

While this may seem unnecessary, it is actually part of a very valuable
business strategy, graphically representing cumulative activity in such a
chart.

The way we have been doing this previously is to show about 20 customers
(grouped according to a close range of values) per chart. That becomes
difficult to read (defeating the purpose of the chart). Also, we can't send
that out to each customer.

 

[Guest]

Tushar: addendum to my first reply:

It would be acceptable to maintain each chart as a separate workbook with
some kind of hyperlink back to the original data source table.

-Peter

 

[Ed Ferrero]

Hi Peter,

You need a macro.

Loop through each row.
Build Chart.
Save Chart.

I have prepared a worksheet that does this and saved it in my charting page
at
http://edferrero.m6.net/charting.aspx look for 'Multiple Chart Builder'
(hint: its down the bottom).

The workbook saves each chart as a .gif file in a folder of your choice.

Ed Ferrero
http://edferrero.m6.net/