automate charting

[ooievaar6]

Hi,
I've imported a textfile looking similar to the following:

apples jan-03 1000 2000 3 4
apples feb-03 2000 3000 4 4
apples mar-03 1010 2020 1 1
apples apr-03 2010 5000 6 6
orange jan-03 2000 4000 3 3
orange feb-03 2000 3000 4 4
orange mar-03 1010 2020 1 1
orange apr-03 2010 5000 6 6
orange may-03 2010 5000 6 6
orange jun-03 2010 5000 6 6
orange jul-03 2010 5000 6 6
orange aug-03 2010 5000 6 6
cherry jan-03 2000 4000 3 3
cherry feb-03 2000 3000 4 4
cherry mar-03 1010 2020 1 1
cherry apr-03 2010 5000 6 6

I've just figured out how to manually get a decent 2-axis line chart
for the apples (one axis for data in the thousands and the second axis
for data between 0 to 10).

What's the simplest route to automate creating individual charts for
the remaining "fruits"? Would sticking an empty row between the
different fruits help in auto detection of the start and stop between
the different fruits (and therefore charts) or would it be quicker for
me to load the remaining (85!) fruits into individual worksheets prior
to automation? How does one go about quickly defining ranges for each
series.

Fortunately or otherwise, this is my first attempt at going beyond the
most basic excel functions.

Rgds,
Ooi.

 

[Tushar Mehta]

What do the four columns of number represent? What are you plotting on
the 2 axis? What role does the month play in the chart?

Depending on those answers, you might be able to use a PivotTable with
an associated PivotChart.

--
Regards,

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