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: How do I see the X axis values with Excel 2010

14 Feb 2013   #1
gelsner

Win7
 
 
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 axis?

Thanks, all help will be appreciated greatly,

/ GE


My System SpecsSystem Spec
.

14 Feb 2013   #2
Neutron16

Windows 8.1 ; Windows 7 x86 (Dec2008-Jan2013)
 
 

Once, I have tried to format axis to show actual values, but I did not succeed. So now I use Data labels. Actual value is shown just above or to the right of each point.
My System SpecsSystem Spec
15 Feb 2013   #3
gelsner

Win7
 
 

I tried using the Data Labels; but they just display for each point the vertical values; what I need to display are the values along the bottom horizontal axis. Sort of frustrating...I know it usually works, but not this time...any help will be really appreciated.
/ GE
My System SpecsSystem Spec
.


15 Feb 2013   #4
Neutron16

Windows 8.1 ; Windows 7 x86 (Dec2008-Jan2013)
 
 

Arighty then.
Right click on your chart, select - Select Data.
In a new window in the sub section
Horizontal (Category) Axis Labels click Edit.
Then select your desired label range.
My System SpecsSystem Spec
16 Feb 2013   #5
gelsner

Win7
 
 

Neutron16,

Ah ha, you may be onto a good thing here -- when I do the above steps; "edit" is not active. Is that a clue to my problem?

/ GE
My System SpecsSystem Spec
16 Feb 2013   #6
Golden

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64
 
 

Quote   Quote: Originally Posted by gelsner View Post
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 axis?
Its designed to do it that way - change the chart type to the XY chart, then turn the marker points off if you like.


Quote:
Line charts
Data that is arranged in columns or rows on a worksheet can be plotted in a line chart. Line charts can display continuous data over time, set against a common scale, and are therefore ideal for showing trends in data at equal intervals. In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis.

You should use a line chart if your category labels are text, and are representing evenly spaced values such as months, quarters, or fiscal years. This is especially true if there are multiple series for one series, you should consider using a scatter chart. You should also use a line chart if you have several evenly spaced numeric labels, especially years. If you have more than ten numeric labels, use a scatter chart instead.
https://office.microsoft.com/en-au/e...x#BMlinecharts

Regards,
Golden
My System SpecsSystem Spec
17 Feb 2013   #7
gelsner

Win7
 
 

Golden,

A huge thanks!! I've been selecting the wrong chart type for years -- so now you've solved both the short-term issue and the longer one too!!

Thanks again,

/ GE
My System SpecsSystem Spec
17 Feb 2013   #8
Golden

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64
 
 

My pleasure - glad its solved
My System SpecsSystem Spec
Reply

 How do I see the X axis values with Excel 2010




Thread Tools





Similar help and support threads
Thread Forum
Bug in Excel 2010?
For my workbook, I have defined the default font to be 11 pt Calibri. However, when I select a row (or column) and select Clear Formats, the cells are reformatted to 10 pt Arial. To me, this seems like a bug. Am I missing something?
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
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,
Microsoft Office
Can't add values to Excel graph.
I just can't get new data to display on this graph (see below): http://www.mediafire.com/imgbnc.php/628220c5ad14e56fcc9c18f3a30331450461e373d13e7498ffb7e5c39e8d57af6g.jpg I enter the values in the table on the left, and they won't show up in the graph! This has just started happening, as you...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Excel - Format Axis - Angle greyed out!?
I made a simple chart plotting economic data from 1960 to present using the year on the time axis. I want to angle the text on a 45 incline for readability. The Custom angle is greyed out. I can choose the Text Direction (Horizontal, Stacked, Rotate 90 degrees, Rotate 270 degrees) but I want...
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 07:15.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App