Excel Double Axis Graph

[cvincent]

My double axis chart is tracking $ values on the left and count on the right. Dates are on the horizontal axis, with the oldest date to the right. The count is charted correctly; i.e. the dates correspond to the count. But the $ amounts are charting backwards. In other words, the $ amounts are not following the dates. The oldest $ amount is on the left at the most current date, while the latest $ amount is on the right at the oldest date.

Any help you can give me to correct this would be greatly appreciated.

Thank you.

 

[Andrew Poulsom]

Please post a small but representative sample of your chart's source data.

 

[cvincent]

[TABLE="width: 549"]
<COLGROUP><COL style="WIDTH: 139pt; mso-width-source: userset; mso-width-alt: 6765" width=185><COL style="WIDTH: 19pt; mso-width-source: userset; mso-width-alt: 914" width=25><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><COL style="WIDTH: 9pt; mso-width-source: userset; mso-width-alt: 438" width=12><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><COL style="WIDTH: 9pt; mso-width-source: userset; mso-width-alt: 438" width=12><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><COL style="WIDTH: 9pt; mso-width-source: userset; mso-width-alt: 438" width=12><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><TBODY>[TR]
[TD="class: xl63, width: 185, bgcolor: transparent"]SAMPLE:


[/TD]
[TD="class: xl64, width: 25, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl65, width: 121, bgcolor: transparent"]9/10/12[/TD]
[TD="class: xl66, width: 12, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl65, width: 121, bgcolor: transparent"]9/9/12[/TD]
[TD="class: xl66, width: 12, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl65, width: 121, bgcolor: transparent"]9/8/12[/TD]
[TD="class: xl66, width: 12, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl65, width: 121, bgcolor: transparent"]9/7/12[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]COUNT[/TD]
[TD="class: xl68, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]50.1[/TD]
[TD="class: xl68, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]48.3[/TD]
[TD="class: xl68, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]57.5[/TD]
[TD="class: xl68, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]52.0[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"] TOTAL SOURCE 1 [/TD]
[TD="class: xl71, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl72, bgcolor: transparent"] $ 19,406 [/TD]
[TD="class: xl71, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl72, bgcolor: transparent"] $ 23,872 [/TD]
[TD="class: xl71, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl72, bgcolor: transparent"] $ 28,000 [/TD]
[TD="class: xl71, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl72, bgcolor: transparent"] $ 32,000 [/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]TOTAL SOURCE 2[/TD]
[TD="class: xl74, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl75, bgcolor: transparent"] $ 188,466 [/TD]
[TD="class: xl74, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl75, bgcolor: transparent"] $ 172,654 [/TD]
[TD="class: xl74, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl75, bgcolor: transparent"] $ 167,800 [/TD]
[TD="class: xl74, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl75, bgcolor: transparent"] $ 152,000 [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: transparent"]GRAND TOTAL[/TD]
[TD="class: xl74, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl77, bgcolor: transparent"] $ 207,872 [/TD]
[TD="class: xl74, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl77, bgcolor: transparent"] $ 196,526 [/TD]
[TD="class: xl74, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl77, bgcolor: transparent"] $ 195,800 [/TD]
[TD="class: xl74, bgcolor: #d7e4bc"] [/TD]
[TD="class: xl77, bgcolor: transparent"] $ 184,000 [/TD]
[/TR]
</TBODY>[/TABLE]

 

[Andrew Poulsom]

Make sure that both x axes are of the same type. Time-scale will run from earliest date to latest date. Category ot Text will run as shown in your source data.

 

[cvincent]

Thank you Andrew for your assistance. Working great now!