• 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

    Hui...

  • 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

priyanka116

New Member
Hi,


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?
 

Hui

Excel Ninja
Staff member
priyanka

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
 
Top