Excel 2007 Chart display problems

**lmp101010** · 09-10-2009, 01:24 PM

The data using a shared X axis but 2 y axis is displaying incorrectly.

The points on the scatter chart are not lining up with the headings on the shared x axis.

It's not a problem when using both column charts but the preferred display is scatter over column.

The attached spreadsheet illustrates the problem.

Any help? Thx

**lecxe** · 09-13-2009, 12:46 AM

Hi

I tried to take a look at it, but you didn't post the charts, you posted pictures of the charts, that are useless because I can't examine the data source, the series and axes configuration, etc.

Can you please post an example with a real chart?

**Andy Pope** · 09-13-2009, 07:05 AM

lecxe the reason lmp101010 posted a picture is that the problem is specific to his pc. The picture allows us to see what he is seeing.

See this post for the actual workbook.
http://www.excelforum.com/excel-char...with-axis.html

Here you can see I asked a question, in order to help, but as yet have recieved no reply.

**lecxe** · 09-13-2009, 12:25 PM

Originally Posted by Andy Pope

lecxe the reason lmp101010 posted a picture is that the problem is specific to his pc. The picture allows us to see what he is seeing.

See this post for the actual workbook.
http://www.excelforum.com/excel-char...with-axis.html

Here you can see I asked a question, in order to help, but as yet have recieved no reply.

Thank you Andy, I did not know that the question had been already posted.