automate generation of many charts

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

In article <uF9EQrz7DHA.4060@tk2msftngp13.phx.gbl>, asdf@asdf.com
says...
> 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
>
>
>

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Neil wrote:

> 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
>
>