Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() If i have data sourced to me like this: Date Price 1 Price 2 Price 3 1/1/2003 2.5 3.2 3.0 1/2/2003 2.6 2.8 2.9 1/1/2004 2.7 3.0 3.1 1/2/2004 2.0 2.8 3.2 1/1/2005 6.0 6.2 6.2 1/2/2005 6.5 6.3 6.4 If I want a line graph with the 3 series related to the Price columns, how can I get the x axis to only reflect the 3 month/day combinations not including the year? When I try this it gives me 6 x axis points for each series. Thanks, Mike. -- mjo73 ------------------------------------------------------------------------ mjo73's Profile: http://www.excelforum.com/member.php...o&userid=30459 View this thread: http://www.excelforum.com/showthread...hreadid=501255 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Producing line and bar graphs on same axis | Charts and Charting in Excel | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
Show quarters and years on x axis of a chart | Charts and Charting in Excel |