Overlapping Cluster Column Chart with Secondary Axis

[bluerog2]

Can you make a cluster column chart with one series data charted on a secondary axis?

For instance, I'd like to show x,000 new customers new customers by month with revenues of $YYY,000 for new customers by month.

The issue is, the revenue would need to be plotted on a different axis because $100,000 next to 3,000 makes the number of customers not viewable.

[TABLE="width: 472"]
<tbody>[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD]Number of Customers[/TD]
[TD="align: right"]2,800[/TD]
[TD="align: right"]2,900[/TD]
[TD="align: right"]3,800[/TD]
[/TR]
[TR]
[TD]Actual Revenue to Show:[/TD]
[TD="align: right"]$370,000[/TD]
[TD="align: right"]$305,000[/TD]
[TD="align: right"]$405,000[/TD]
[/TR]
</tbody>[/TABLE]


Thank you for your help.

 

[bluerog2]

I'm actually good at graphing. I'm going to say it's not possible and just use a line with markers on a second axis. I can make the markers rectangular and it'll be as good as it gets.

Can you make a cluster column chart with one series data charted on a secondary axis?

For instance, I'd like to show x,000 new customers new customers by month with revenues of $YYY,000 for new customers by month.

The issue is, the revenue would need to be plotted on a different axis because $100,000 next to 3,000 makes the number of customers not viewable.

[TABLE="width: 472"]
<tbody>[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD]Number of Customers[/TD]
[TD="align: right"]2,800[/TD]
[TD="align: right"]2,900[/TD]
[TD="align: right"]3,800[/TD]
[/TR]
[TR]
[TD]Actual Revenue to Show:[/TD]
[TD="align: right"]$370,000[/TD]
[TD="align: right"]$305,000[/TD]
[TD="align: right"]$405,000[/TD]
[/TR]
</tbody>[/TABLE]


Thank you for your help.