Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
t4gbg
 
Posts: n/a
Default How do I set up column charts' x values in 'm' ie. 300m, 600m etc

I am learning charting in Excel. How do I display x values axis as 300m,
600m, 900m while the values displayed inside the columns are 256.4, 488.7 and
822.3
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

You make an XY chart not a Line chart. Line charts are used when the
x-values are categories (text or numbers that are not used numerically like
serial numbers)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"t4gbg" wrote in message
...
I am learning charting in Excel. How do I display x values axis as 300m,
600m, 900m while the values displayed inside the columns are 256.4, 488.7
and
822.3



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running total w/2 columns - Excel Anna / Ideal Excel Worksheet Functions 14 August 10th 05 04:28 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
column values to a cell with comma seperated Raju Boine. Excel Worksheet Functions 3 July 27th 05 03:30 PM
How to dates column with values in next column Carlton A. Barlow Excel Discussion (Misc queries) 1 April 18th 05 04:28 AM
Hiding Values Below Z Axis Minimum Value on Axis Charts TryingToExcel Charts and Charting in Excel 1 February 18th 05 03:55 AM


All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"