I have records in a table which contains fields like:
Project No, Month, april, May, Jun, Jul etc....

Each Project No can have entries like:

PROJECT NO, Month, April, May, June, etc...
1000, April, 100, 110, 113,
1000, May, 123, 500, 321,
1000, Jun, 234, 345, 234,

How do I create a line graph, With the series being 'month',
i.e. April values 100,110,113.

Thanks


Mark

Your data will need to be changed to something that can be graphed.

You will need to get your data like:
PROJECT NO, Month, April, May, June, etc...
1000, April, 100, 123, 234,
1000, May, 110, 500, 345,
1000, Jun, 113, 321, 234,

How many columns are there (April, May June etc)?

How Many Months are there ?

Hi Mark,

I re-read your request, and I'm not sure that I understand what you want to plot.

quote:

How do I create a line graph, With the series being 'month'

Does this mean your graph will have twelve lines?
What will the X-Axis show?
I think what is confusing is that you have a column called "April" and a row where Month="April". So which is April - the column or the row?

If your data does resemble what you show, have you tried:
SUM April May June ACROSS Month

quote:

Originally posted by Waz:
Your data will need to be changed to something that can be graphed.

You will need to get your data like:
PROJECT NO, Month, April, May, June, etc...
1000, April, 100, 123, 234,
1000, May, 110, 500, 345,
1000, Jun, 113, 321, 234,

How many columns are there (April, May June etc)?

How Many Months are there ?

Hi Waz,

There are 12 columns, one for each month of the year. I'll be off line for a week, but I'll be back. Thanks Mark

quote:

Originally posted by Twanette:
Hi Mark,

I re-read your request, and I'm not sure that I understand what you want to plot.

quote:

How do I create a line graph, With the series being 'month'

Does this mean your graph will have twelve lines?
What will the X-Axis show?
I think what is confusing is that you have a column called "April" and a row where Month="April". So which is April - the column or the row?

If your data does resemble what you show, have you tried:
SUM April May June ACROSS Month

Hi Twanette,
Yes, in theory the graph could contain 12 lines.
The table is confusing. Each Month, the field ‘Month’ returns are received which show how much has been spent in the months gone by and what is forecasted for the rest of the year. The x axis will show the value for each of fields April ,May June etc and the series will be the month field.
I have not tried SUM April May June ACROSS Month.
I am off line for a week, but I’ll be back, Thanks
Mark