Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Defining X axis in Charts
I am using Office XP's Excel and this is probably a stupid question but
I cannot find the answer on my own. I am creating a line chart from data in Excel where the X axis is a series of dates. Yet using the Chart Wizard all I can get the X to show is consecutive numbers (1.3.5.7.9.etc.) Is there a way to make the X axis show the data in a corresponding column of data that I have within Excel? There seems to be no place I can assign this date data to the X axis so it shows up there instead of consecutive numbers Excel creates for the X axis. Hope I am clear. Jeff |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Defining X axis in Charts
In the chart window, try modifying what you have in
Chart - Source Data "Jeff" wrote: I am using Office XP's Excel and this is probably a stupid question but I cannot find the answer on my own. I am creating a line chart from data in Excel where the X axis is a series of dates. Yet using the Chart Wizard all I can get the X to show is consecutive numbers (1.3.5.7.9.etc.) Is there a way to make the X axis show the data in a corresponding column of data that I have within Excel? There seems to be no place I can assign this date data to the X axis so it shows up there instead of consecutive numbers Excel creates for the X axis. Hope I am clear. Jeff |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Defining X axis in Charts
Thank you. Found it under Series/ Category X labels which I had missed.
Jeff "Barb Reinhardt" wrote in message In the chart window, try modifying what you have in Chart - Source Data "Jeff" wrote: I am using Office XP's Excel and this is probably a stupid question but I cannot find the answer on my own. I am creating a line chart from data in Excel where the X axis is a series of dates. Yet using the Chart Wizard all I can get the X to show is consecutive numbers (1.3.5.7.9.etc.) Is there a way to make the X axis show the data in a corresponding column of data that I have within Excel? There seems to be no place I can assign this date data to the X axis so it shows up there instead of consecutive numbers Excel creates for the X axis. Hope I am clear. Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining default fonts for charts | Charts and Charting in Excel | |||
Defining scale on y axis | Excel Discussion (Misc queries) | |||
defining major units on chart axis | Charts and Charting in Excel | |||
formula for defining axis maximum and increments | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |