View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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