Simple question about Charts

[TAG423]

This aggrevates me. You set up a chart in excel and drag the y-axis to a specific spot in your chart. Then the next time you open it, the y-axis position has moved!

Any suggestions?

 

[Mark W.]

What do you mean by "drag the y-axis"?

 

[TAG423]

Example: I have a spreadsheet underneath the chart. The data is for Jan. through Dec moving from left to right. I don't want to use a data table, so I simple place the y-axis to start at Jan on my spreadsheet. This way all the information on the spreadsheet lines up with the chart information. However, when I save it and return later, the y-axis will move slightly.

 

[Mark W.]

Perhaps your chart is adjusting to different x-axis values. What's your "Object positioning" setting on the Format Chart Area Properties dialog?

 

[TAG423]

It is set to "Move and size with cells".