trouble with charts

[Gregvg]

When I refresh the data for my chart for one date range I get a chart that looks the way i designed it. See attachment.

When I refresh the data with a different date range it changes the whole design of the chart. See attachment

What could possible cause this to happen?

 

[DavidAtWork]

How are you refreshing the data, and how different are the values from one date range to the 2nd date range
David

 

[Gregvg]

I have a parameter form with a combobox that selects the year for the query that generates the chart, then opens the chart. As far as the data yes it's different because it is a different year but the structure is the same. What troubles me is the actual design of the chart changes even though the process used to run them is the same.

 

[DavidAtWork]

interesting, so your chart is running off the same data source (either a table or query as a rowsource), albeit with different records according to selected year. All I can think is the new values are so radically different, either by record count or scale, the self scaling/sizing might be doing something.
Do you use vba to set anything in the graph after updating the data?
David

 

[Gregvg]

What bothers me is how the formatting changes. I have 2 axis one represented by a bar graph and the othe by a line graph. Even that changes when the chart is refreshed from year to year. that makes no logical sense to me.

 

[DavidAtWork]

Can you post the code that is executed when the data is refreshed and also what loads the graph
David