automate generation of many charts

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hi

I am trying to build a desktop application that will auto-generate graphs
for us, based on the table below.

The figures relate to usage levels per part. There are about 8000 rows, and
i require a graph for each ROW !
The title of the graph is the part number, the first line on the graph is
the usage per period, and the second line is the average usage which is
drawn across all periods. the x-axis labels is 'period n', per
column.


PartID Description Period 10 Period 11
Period 12 AverageUsage
00100019 SCREW 0.05 0 0
0.00625
00200010 NAIL 0.05 0.1
0 0.01875


how can i build some code/macro/command that can do this ?
i thought about being able to type in the partID to generate the graph, or
place a button next to the row which generates a graph for that row.

The raw data comes from the mainframe in .csv format, and then i import that
into excel. I also have MSAccess at my disposal.

can anyone help? i am using office xp
Thanks
 
I definitely would not even try and generate 8,000 graphs at the same
time. The easiest would be to do one and customize it for each item of
interest. Basically, automate the appropriate example in the Dynamic
Charts tutorial on my site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Neil -

The code to spit out charts automatically isn't too complicated. Do you
need a chart for each row, or for whatever row is indicated by the user.
Either is easy enough to do.

The problem is that 8000 charts is rather a lot. If you do need 8000
charts, where will you put them? Excel will choke after many fewer
charts than that on a single worksheet.

- Jon
 
Back
Top