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!

Try this:

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

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


"Neutron1871" <(E-Mail Removed)> wrote in message
news:839D3AF5-5304-48C9-9071-(E-Mail Removed)...
>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!

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" wrote:

> Try this:
>
> http://peltiertech.com/Excel/Charts/...olAndLine.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "Neutron1871" <(E-Mail Removed)> wrote in message
> news:839D3AF5-5304-48C9-9071-(E-Mail Removed)...
> >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!
>
>
>

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
_______


"Neutron1871" <(E-Mail Removed)> wrote in message
news:CEF4765A-0025-4FCE-97D8-(E-Mail Removed)...
> 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" wrote:
>
>> Try this:
>>
>> http://peltiertech.com/Excel/Charts/...olAndLine.html
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> http://PeltierTech.com
>> _______
>>
>>
>> "Neutron1871" <(E-Mail Removed)> wrote in message
>> news:839D3AF5-5304-48C9-9071-(E-Mail Removed)...
>> >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!
>>
>>
>>

You are an Excel Genius, thank you!!!

"Jon Peltier" wrote:

> 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
> _______
>
>
> "Neutron1871" <(E-Mail Removed)> wrote in message
> news:CEF4765A-0025-4FCE-97D8-(E-Mail Removed)...
> > 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" wrote:
> >
> >> Try this:
> >>
> >> http://peltiertech.com/Excel/Charts/...olAndLine.html
> >>
> >> - Jon
> >> -------
> >> Jon Peltier, Microsoft Excel MVP
> >> Tutorials and Custom Solutions
> >> http://PeltierTech.com
> >> _______
> >>
> >>
> >> "Neutron1871" <(E-Mail Removed)> wrote in message
> >> news:839D3AF5-5304-48C9-9071-(E-Mail Removed)...
> >> >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!
> >>
> >>
> >>
>
>
>