Graphing two data sets which start at different points on th

[Mel C Roberts]

Hi,
Can anyone help?
I am sure i am having a blonde day here!

I have two data sets to put into a basic graph.
One is a monthly figure which runs from September to August (pulled from the spreadsheet) Sep - Aug will form the labels for the x axis.
The yearly informaiton is only available from April to August, so i need it to sit on the same axis but to start in April not September.

For some reason i am having real problems.
Can anyone help?

 

[PaddyD]

"For some reason i am having real problems"

What are they?? Post back with more detail about the results you're currently getting.

 

[Mel C Roberts]

Sorry.
"They" are two sets of data, depicting a monthly average.
For example the data may be 10, 12, 11, 8, 4, 7, 9, 13, 20, 11, 8, 19. Where 10 is the figure for September (Monthly) through to 19 being the figure for August.
I then have year to date summary information to show on the same graph but only starting in March. ie 13, 12, 11, 10, 9, 9
Which i need to show on the same axis but relative to the month to which the data relates ie starting in March not September.

 

[PaddyD]

On 2002-09-02 02:16, Mel C Roberts wrote:
Sorry.
"They" are two sets of data, depicting a monthly average.
For example the data may be 10, 12, 11, 8, 4, 7, 9, 13, 20, 11, 8, 19. Where 10 is the figure for September (Monthly) through to 19 being the figure for August.
I then have year to date summary information to show on the same graph but only starting in March. ie 13, 12, 11, 10, 9, 9
Which i need to show on the same axis but relative to the month to which the data relates ie starting in March not September.

Mel,

This should be fairly straightforward!

If you had three columns: month, average, YTD, with the data elements associated with the right month it should all turn out OK. If you're having problems, I guess your data isn't set up this way! How is it set up - where is your data on the spreadsheet etc. may be download the html maker addin from the link below this post & post back with a snapshot of your spreadsheet.

Paddy