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]

SAMPLE:		9/10/12		9/9/12		9/8/12		9/7/12
COUNT		50.1		48.3		57.5		52.0
TOTAL SOURCE 1		$ 19,406		$ 23,872		$ 28,000		$ 32,000
TOTAL SOURCE 2		$ 188,466		$ 172,654		$ 167,800		$ 152,000
GRAND TOTAL		$ 207,872		$ 196,526		$ 195,800		$ 184,000

<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>
</TBODY>

 

[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!