View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Horizontal dates

Format Axis/ Scale
Type 15-Aug as your minimum, and 7 as the major unit.

You haven't told us what type of chart you are using, but XY is usually the
best bet.
--
David Biddulph

"dartmoor" wrote in message
...
Am I being dull here? I am trying to run weekly dates on the horizontal
axis
- say Aug 15th onwards. That is - Aug 15, Aug 22, Aug 29 etc. But I
cannot.
I am clicking max, minor units, fixed, automatic, date axis buttons but I
am
getting no where except going completely nuts.

I've bought a book. No help at all. Been on Microsoft Help. Nothing.
Lots of what to do but doesn't solve my problem. The previous Excel
version
was much easier.

Am I alone with this query? Can anyone out there help? How do you put
weekly dates on a horizontal axis - without adding to my total
frustration?
Arrgh!!

tim k
--