Try this:

http://peltiertech.com/Excel/Charts/...olAndLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Neutron1871" wrote in message
...
I have a chart that is using columns for category "A" on the primary x-axis
(a $ amount). This category is broken down first by person, then by
month.
So essentially from left to right the columns will be person "1" and month
"1", person "1" and month "2", person "1" and month "3", person "2" and
month
"1", and so on....

The chart is also using lines to mark category "B" on the secondary x-axis
(a $ amount that is a portion of category "A", but not a percentage.
Essentially category "B" will never be larger than category "A".). This
category is broken down in the same fashion as category "A" (first by
person,
then by month).

The problem I'm running into is that the line for month "1", category "B"
does not hover over month "1", category "A" column. All lines basically
hover over the middle column month for each person. Is there any way to
get
each month line to hover over each month column?

Thx!