• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Bar and Line in one chart on 2007


New Member

I need to make a chart with count on left side (generally values between 1-50) and monetary value on the right (values between 5K to 500K). The count should be a line graph and monetary value should be vertical bars.

Could you help pls?


Excel Ninja
Staff member

Setup 3 columns or rows of data

1st Row/col has the labels for the various data eg Month/Yr etc

2nd & 3rd Row/col will have the data values

Select all the data including labels (3 rows or columns)

Make a Bar Chart of data with the wizard

Select either bar, right click select Chart Type and change the chart type to Line

Now right click on the line and select Format Data Series,

Select Axis and change the value to the secondary axis

Change scales, titles etc to suit