Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 Chart Left Axis is in middle of chart

19 Feb 2013   #1
gelsner

Win7
 
 
Excel 2010 Chart Left Axis is in middle of chart

Hi,

For some reason, the numbers for the left axis are in the middle of my chart and I have highlighted the axis and reformatted to no avail.

How can I change the settings so it is shown on the far left as usual?

I've uploaded a jpg showing the problem.

A big thanks in advance,

/ GE





Attached Images
 
My System SpecsSystem Spec
.
19 Feb 2013   #2
Golden
Microsoft MVP

Windows 7 Ult. x64
 
 

Thats the normal default behaviour since you have both positive and negative values on the X-axis - the chart assumes you want to see the value extremes so it places the y-axis at the zero position of the x-axis.

You can shift the Y-axis to the far left by using the format x-axis option, like this:

-capture.png


My System SpecsSystem Spec
20 Feb 2013   #3
gelsner

Win7
 
 

Golden,

You solved that so quickly after I frustrated over it for days!! Great and thanks. My biggest mistake was trying to reformat the vertical numbers rather than the horizonital number layouts.

See how nice it looks with your suggestions:



Cheers and thanks again,

/ GE


Attached Images
 
My System SpecsSystem Spec
.

20 Feb 2013   #4
Golden
Microsoft MVP

Windows 7 Ult. x64
 
 

My System SpecsSystem Spec
Reply

 Excel 2010 Chart Left Axis is in middle of chart




Thread Tools




Similar help and support threads
Thread Forum
Can I create a pie chart with data in an existing excel file?
Where I work an excel sheet with any and all "failed activities" (we're not getting paid) is sent out every wednesday. How can I highlight specific cells (for a specific person) and have that chart show how much of the failed activities belong to them. They obviously know that, but this will...
Microsoft Office
How do I see the X axis values with Excel 2010
Hi, I know it's a basic question -- and I've been charting with Excel for a while; but now all of a sudden when I make a Line Chart with Excel 2010; the horizonital values shown are just sequential numbers of the real X values. How do I get Excel to show the actual X values on the horizonital...
Microsoft Office
Microsoft Excel 2010 - chart formatting question
Hello, I've just made a pretty decent scheme in my Excel. It's all good but I would like it to fill a whole A/4 sized piece of paper, by increasing the size of the cells as well as the text in them proportionally, so that I don't have any unused, blank cells. Is there a simple way to do this? ...
Microsoft Office
Bubble chart
I would like to use Excel 2010 to create a bubble chart such as this one: http://www.pairofdocs.net/images/BubbleChart.jpg Would you please help me with the following: 1. How can I make each row have a different color? 2. How can I use other than numeric axis labels? If this is not...
Microsoft Office
Non business use chart?
Has anyone seen a chart from 09-10 of what OS people use excluding businesses and schools, which I believe is why XP always seems to win, because its too expensive to upgrade or something like that.
General Discussion
Excel Line Chart
I am trying to do a simple line chart using Excel in Office 2007. I have the dates in weekly order and two columns of prices, I want the chart to show the change in prices each week. I select these three columns then go to Insert and select the first line chart shown. It displays the price...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 17:44.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App