| View previous topic :: View next topic |
| Author |
Message |
scott1x
General User
Joined: 10 Nov 2007
Posts: 5
|
 Posted: Sat Nov 10, 2007 8:36 pm Post subject: [SOLVED] X axis labels - how to? |
 |
|
column A - Date
Column B - Value.
Chart value by date.. no problem BUT I cannot figure out how to get the date label from column A to show as the x axis label. All I can get is a row number there. How do I get the date to show as the x axis labels?
Last edited by scott1x on Sun Nov 11, 2007 8:19 am; edited 1 time in total |
|
| Back to top |
|
 |
dmd
General User
Joined: 17 Dec 2005
Posts: 16
|
| Posted: Sun Nov 11, 2007 5:30 am Post subject: |
|
|
I am using version 2.3.
After selecting Insert, Chart..., the chart wizard is displayed and in step two there is an option to select "First column as label" - selecting that option will replace Row 2, Row 3, etc. with the appropriate dates.
The option to select "First column as label" is also available if you right click in the x- axis and select Data Ranges... |
|
| Back to top |
|
|
scott1x
General User
Joined: 10 Nov 2007
Posts: 5
|
| Posted: Sun Nov 11, 2007 8:01 am Post subject: |
|
|
| dmd wrote: | I am using version 2.3.
After selecting Insert, Chart..., the chart wizard is displayed and in step two there is an option to select "First column as label" - selecting that option will replace Row 2, Row 3, etc. with the appropriate dates.
|
I am also using 2.3 but checking "first column as label" leaves me with and empty chart an a y axis that has a scale that seems to be related to nothing in my chart. It seems to be using the "B" column (my desired x axis), then, and ignoring the A column, my desired x axis lables.
I'm using WindowsXP. |
|
| Back to top |
|
|
scott1x
General User
Joined: 10 Nov 2007
Posts: 5
|
| Posted: Sun Nov 11, 2007 8:19 am Post subject: |
|
|
I figured out what I was doing wrong... got it now... Thanks for the pointers!!!!
Scott  |
|
| Back to top |
|
|
|
