dan_l
Active Member
Ok, I've got two series of data:
[sales] [salary] [sales] [salary]
Series 1 is _all data_ except for the area I want to highlight. Series 2 is just the highlighted series. It's determined with some if formulas, so in the end it looks like
[sales] [salary] [sales] [salary]
1 10
5 20
8 24
2 18
The first series plots out just fine. The second series refuses to move off the left hand side of the chart. I've tried putzing with the axis, tried double checking the data. I can't figure out what's wrong.
[sales] [salary] [sales] [salary]
Series 1 is _all data_ except for the area I want to highlight. Series 2 is just the highlighted series. It's determined with some if formulas, so in the end it looks like
[sales] [salary] [sales] [salary]
1 10
5 20
8 24
2 18
The first series plots out just fine. The second series refuses to move off the left hand side of the chart. I've tried putzing with the axis, tried double checking the data. I can't figure out what's wrong.