Simple question about Charts

TAG423 · Feb 20th, 2002, 08:47 AM

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. · Feb 20th, 2002, 08:50 AM

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

TAG423 · Feb 20th, 2002, 08:55 AM

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. · Feb 20th, 2002, 09:05 AM

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

TAG423 · Feb 20th, 2002, 09:48 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 08:47 AM	#1
TAG423 Board Regular Join Date: Feb 2002 Posts: 51	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?

Feb 20th, 2002, 08:50 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	What do you mean by "drag the y-axis"?

Feb 20th, 2002, 08:55 AM	#3
TAG423 Board Regular Join Date: Feb 2002 Posts: 51	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.

Feb 20th, 2002, 09:05 AM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Perhaps your chart is adjusting to different x-axis values. What's your "Object positioning" setting on the Format Chart Area Properties dialog?

Feb 20th, 2002, 09:48 AM	#5
TAG423 Board Regular Join Date: Feb 2002 Posts: 51	It is set to "Move and size with cells".