| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut key for aligning data in cell | Excel Discussion (Misc queries) | |||
| ALIGNING TWO ARRAYS OF DATA VALUE | Excel Worksheet Functions | |||
| Aligning decimal numers to the centre of the cell and aligning dec | Excel Discussion (Misc queries) | |||
| Aligning Decimal Points with non-numeric data | Excel Discussion (Misc queries) | |||
| Aligning Data Within Merged Cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
