I doubt it should be this complicated :)

If you want to send your file I will have a look see.

andy AT andypope DOT info

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"lbb" wrote in message
...
Yeah -- I cleared up some of my confusion -- I thought it was a secondary
Y
axis, didn't understand it was a secondary x axis. I got that part
straightened out, but it still isn't working. For example, one of the
series
that I want to use to create a date marker has a value of 11000 (which is
where I want the point to show up as far as the Y value), category (x
axis)
labels is the whole range for the regular chart (12 of these, one for each
month) and secondary label is the cell containing the date where I want
the
bar to appear. It shows up, but it's nowhere near the date in the
secondary
label. How exactly is Excel supposed to know where to place it?

I have to say, this all seems like one great big almighty kluge to do
something that ought to be a fairly standard function.


"Andy Pope" wrote:

Hi,

You mean the part about adding new series, moving it to the secondary
axis
and formatting the secondary x axis so specific dates correspond to dates
and not category tickmarks?