Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() Hi, I have this problem as well. I've tried doing this, but it doesn't seem to work. For example, I have the following data to plot: 01/31/95 0.29623 12/29/95 0.19822 12/31/96 0.13931 12/31/97 0.33036 12/31/98 0.082194 12/31/99 0.23669 12/29/00 -0.25575 12/31/01 0.023404 12/31/02 -0.11949 12/31/03 -0.018228 12/31/04 0.12326 with the dates being the actual dates I wish to plot on my x-axis. As you can see, they are irregular dates. Regardless of how I try (with ensuring the Minor Unit is on Days and the Major on months), I can't seem to get the right combination to have Excel plot the actual dates above. Instead, it seems to keep defaulting to the last day in January, probably due to the first data point in the date series. Does anyone have any ideas how I would fix this to get the actual dates to plot on the x-axis? Thanks, -Pete -- Peter Bernadyne ------------------------------------------------------------------------ Peter Bernadyne's Profile: http://www.excelforum.com/member.php...fo&userid=7017 View this thread: http://www.excelforum.com/showthread...hreadid=486649 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Want graph with 2 axis, but bars overlap when second axis added | Charts and Charting in Excel | |||
How to specify values for X axis in a Graph | Charts and Charting in Excel | |||
2 axis bar graph | Excel Discussion (Misc queries) | |||
How do you do a graph with a second Y axis? | Excel Discussion (Misc queries) | |||
Y Axis - Horizontal Bar Graph | Charts and Charting in Excel |