Graph labels will not update

[SASHA_D]

Hi there everyone,

I'm in need of some urgent help!!......
I have a form that has a graph on it.
The form's record source is a query with fields M1, M2, M3, M4, M5, M6.
On the graph I have renamed these to represent months M1 being July '03, M6 being Dec '03 and so on.
I now want to change the month labels so that the same fields are called different months, M1 being Nov '03, M2 being Dec '03 and so on.
I change these on the graph and everything is fine, so I save the graph and close the form. When I go back to view the form, the graph hasn't saved the changes and is displaying the old month labels. I can't figure out why it is not saving these, I've been looking at it for ages and it's now getting pretty urgent. Any suggestions would be appreciated!

Many thanks,

Sasha_D

 

[IgorB]

I think you need go to the Graph property, find RecordSource and make field changes there.

 

[SASHA_D]

Thanks for the reply,

When you say go to the graph property where do you mean exactly?

I've clicked on the graph, then properties, then 'rowsource'?
If I click into rowsource it gives me the query that it's based on.
This shows the fields M1, M2, M3, M4, M5 etc.
It doesn't show the month labels that are displayed when viewed.
If I change these fieldnames in the query it does not change what is viewed on screen.
The query is called 'Monthly data' and has fields M1, M2, M3, and so on. The form is called 'monthly issues form' and contains a graph.
The graph has the fields M1, M2 etc. labelled as July '03, Aug '03 and so on.
I want to change these labels. I can click into the graph and I can then type over them on the datasheet and they change! I then save the form and close it. When I reopen the form, the labels are back to their original values!!
I can't seem to change these labels and it is driving me mad!

thanks again!,
Sasha

 

[SASHA_D]

Anyone got any ideas????
I am getting very desperate now!

 

[R6Flyer]

Can you post the record source for the graph.

 

[SASHA_D]

Hi there,

this is the record source:-

SELECT [Monthly Issues Data].Supplier, [Monthly Issues Data].M8, [Monthly Issues Data].M9, [Monthly Issues Data].M10, [Monthly Issues Data].M11, [Monthly Issues Data].M12
FROM [Monthly Issues Data];


thanks,

Sasha_D

 

[R6Flyer]

OK, change the recordsource to:

SELECT [Monthly Issues Data].Supplier, [Monthly Issues Data].M8 AS [Enter Relevant Graph Label], [Monthly Issues Data].M9  AS [Enter Relevant Graph Label], [Monthly Issues Data].M10 AS [Enter Relevant Graph Label], [Monthly Issues Data].M11 AS [Enter Relevant Graph Label], [Monthly Issues Data].M12 AS [Enter Relevant Graph Label]

 

[IgorB]

You Graph Chart based on RowSource. Your fields M1 etc. presents in Chart as in horizontal line. Sequence of months depend on M1,M2 etc.
You have to manipulate with your fields values(sequence) in the query in RowSource.
It works for me in Report Graph Chart.