LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
xm_102
 
Posts: n/a
Default


Thank you both for your answers. However, I can't make sense of them...I
should explain more properly.

I have 21 values. In one column, the points in time: 20000, 19000...0.
In the second col, the values: -116, -107...0. In another program I
tried a while ago there was the option "use first column as label"
which would automatically use the first column to label the x-axis.
Couldn't find that here, so I marked just the second column:

Step 1: graph type -choose Line Graph, with each value highlighted
Step 2: input -choose just the second column
Step 3: alternatives
-try a) in "axis", choose "x-axis: automatic" Output is a graph with
x-axis labeled 1...21. No formatting alternatives for changing 1 to
20000 etc.
-try b) "x-axis: date". Nothing here either.

If I try to reverse the order of the labels, the values get reversed
too. I don't want that.

This is MS Excel 2002 (10.2614.2625) in Swedish, by the way.

Max


--
xm_102Posted from http://www.pcreview.co.uk/ newsgroup access

 
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
Setting x axis scale to time with variable intervals webbuzzard Charts and Charting in Excel 1 June 27th 05 07:13 PM
can't change how data on 2nd axis is being displayed Rebekah Charts and Charting in Excel 1 May 4th 05 02:51 PM
Show quarters and years on x axis of a chart Kacee Charts and Charting in Excel 3 March 19th 05 03:42 AM
Second X axis at top of chart? Phil Hageman Charts and Charting in Excel 1 December 29th 04 01:48 PM
Graphing Reversing the Axis Michael R Middleton Setting up and Configuration of Excel 0 November 30th 04 10:59 PM


All times are GMT +1. The time now is 04:09 AM.

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"