If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|