Column-Line Chart w/ Dates

[Guest]

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!

 

[Jon Peltier]

Try this:

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

- Jon

 

[Guest]

That worked great Jon!! I used the second method on your website to create
my chart.

However, what is happening now is that the lines are connecting by month
from person "1" to person "2" to person "3". I want the lines to connect by
person from month "1" to month "2" to month "3". Is that possible?

 

[Jon Peltier]

Rearrange the data so that all points you want to link by a line are in the
same series, i.e., in the same column of the worksheet.

- Jon

 

[Guest]

You are an Excel Genius, thank you!!!

Rearrange the data so that all points you want to link by a line are in the
same series, i.e., in the same column of the worksheet.

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