Data aligning with axis
 

I have a 2 line chart in 2007
Has two different values for same time periods, but some prior data is
missing for one time period.
a b
FY02 .17
FY03 .25
FY04 .33 .18
FY05 .42 .26
FY06 .49 .33

It keeps moving my "b" line back to FY02???
Not starting underneath my "a" line in FY04?
Any suggestions?
Thanks,

--
Charlie

Data aligning with axis
 

Hi,

Using a normal line chart I can not duplicate this in xl2007. Line b starts
at the 3 category.

If I change the chart type to Stacked Line then it appears that line B
covers Line A for the first 2 FY categories. This would be expected.
What sub-type of chart are you using?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Charlie" wrote in message
...
I have a 2 line chart in 2007
Has two different values for same time periods, but some prior data is
missing for one time period.
a b
FY02 .17
FY03 .25
FY04 .33 .18
FY05 .42 .26
FY06 .49 .33

It keeps moving my "b" line back to FY02???
Not starting underneath my "a" line in FY04?
Any suggestions?
Thanks,

--
Charlie

Data aligning with axis
 

I charted it at home in 2003 using chart wizard and it worked fine???
Thanks for your help.
--
Charlie


"Andy Pope" wrote:

Hi,

Using a normal line chart I can not duplicate this in xl2007. Line b starts
at the 3 category.

If I change the chart type to Stacked Line then it appears that line B
covers Line A for the first 2 FY categories. This would be expected.
What sub-type of chart are you using?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Charlie" wrote in message
...
I have a 2 line chart in 2007
Has two different values for same time periods, but some prior data is
missing for one time period.
a b
FY02 .17
FY03 .25
FY04 .33 .18
FY05 .42 .26
FY06 .49 .33

It keeps moving my "b" line back to FY02???
Not starting underneath my "a" line in FY04?
Any suggestions?
Thanks,

--
Charlie