View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Hal[_2_] Hal[_2_] is offline
external usenet poster
 
Posts: 3
Default Dates in Chart Legends

Andy,

Thanks. That did the trick.
--
Hal the CFO


"Andy Pope" wrote:

Hi,

Sounds like the axis is plotting as time series rather than categories.
Assuming you are using xl2007, as you mention there was a similar
problem in xl2003.
Select axis and display Format dialog. Select Axis Options and set axis
type as Text.

Cheers
Andy

Hal wrote:
The data is formatted to produce 11/19/2008. I changed it to three other
date formats. I still have extra dates in the labels.

Thanks.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info