What chart do I use ?

[trojnfn]

I need to plot a chart with two lines and one bar, with dual Y axis. The bar would represent the total for a city and one line would would be the average for that city. The other line would be the second Y axis and would be the total dollar amount for the city.

What chart would I use for this ?

So far, the only one I found was the combination dual Y with two bars and one line, in 3D. I used it and one bar is the city and the other bar is the average and the line is the total dollar amount with the second Y axis. This seems to work but the boss does not like it and wants one bar and two lines with dual Y axis.

Is there one for one bar and 2 lines in 2D ? I have another chart using the combination bar and line with dual Y axis in 2D,  but I just need one with a second line for the second Y axis.

Thanks for any help.

[Guest Madhumita]

Hi,

You can use the MSCombiDY2D.swf to get one bar and 2 lines in 2D.

 

I am attaching a sample XML for your reference.

Hope this helps.

data.xml