1. 

   priyanka116
   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?

   Posted 3 months ago #
2. 

   Hui
   Excel Ninja

   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

   Posted 3 months ago #
3. 

   priyanka116
   Member

   Hui.... thanks a lot... task done.

   Posted 3 months ago #

RSS feed for this topic

Reply

You must log in to post.