Create separate chart for each row in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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