#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default x-axis value

good day!

my x-axis value are 12.4, 27, 35. it shows these values in equal
distribution (or spacing). what i want the value to be like 5, 10, 15 up to
40 and the tick mark of 12.4 is somewhere inbetween 10 and 15. am using a
line chart.

thanks!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 762
Default x-axis value

benj -

Do not use a Line chart type.

Use an XY (Scatter) chart type, which you can format to have lines
connecting the markers.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"benj" wrote in message
...
good day!

my x-axis value are 12.4, 27, 35. it shows these values in equal
distribution (or spacing). what i want the value to be like 5, 10, 15 up
to
40 and the tick mark of 12.4 is somewhere inbetween 10 and 15. am using a
line chart.

thanks!



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default x-axis value

thanks Mike!

"Mike Middleton" wrote:

benj -

Do not use a Line chart type.

Use an XY (Scatter) chart type, which you can format to have lines
connecting the markers.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"benj" wrote in message
...
good day!

my x-axis value are 12.4, 27, 35. it shows these values in equal
distribution (or spacing). what i want the value to be like 5, 10, 15 up
to
40 and the tick mark of 12.4 is somewhere inbetween 10 and 15. am using a
line chart.

thanks!




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
Need PivotChart x axis to cross Y axis at minimum Y axis value Aaron Charts and Charting in Excel 1 August 17th 07 08:51 AM
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) Tom Excel Discussion (Misc queries) 1 May 29th 07 01:03 PM
Adding data on Axis Major Gridlines next to Category Axis Collums jblittlejohn New Users to Excel 0 July 10th 05 12:17 PM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another John Smith Charts and Charting in Excel 7 December 21st 04 08:26 PM


All times are GMT +1. The time now is 07:02 AM.

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

About Us

"It's about Microsoft Excel"