Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bugjam1999
 
Posts: n/a
Default Combined bar and line chart (two Y axis) how to make excel know which data goes where


Hello all,

after the super fast problem fixing last time i had a problem, i'd like
to ask the excel collective for some more help... :)

now trying to plot a combined bar chart and line graph. I basically
want all the sets of data except one to appear as columns plotted
against the axis on the left and the last set of data (which is a
cumulative value of the data appearing for the columns) plotted against
the right hand axis as a line.

I can plot the graph fine, but out of the 7 sets of data which i want
to appear as 6 sets of columns and one line, i get four sets of columns
and three sets of lines. How do i tell excel to plot all except the
last set of data against the left and then the last against the right?

Help!

thanks in advance :)

Bug.


--
Bugjam1999
------------------------------------------------------------------------
Bugjam1999's Profile: http://www.excelforum.com/member.php...o&userid=26178
View this thread: http://www.excelforum.com/showthread...hreadid=469801

  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

Easiest way is to create the chart as column based on all data. The
select the series which you want as a line and right click and change
the chart type to Line. Double click the line series and change the Axis
to secondary.

Cheers
Andy

Bugjam1999 wrote:
Hello all,

after the super fast problem fixing last time i had a problem, i'd like
to ask the excel collective for some more help... :)

now trying to plot a combined bar chart and line graph. I basically
want all the sets of data except one to appear as columns plotted
against the axis on the left and the last set of data (which is a
cumulative value of the data appearing for the columns) plotted against
the right hand axis as a line.

I can plot the graph fine, but out of the 7 sets of data which i want
to appear as 6 sets of columns and one line, i get four sets of columns
and three sets of lines. How do i tell excel to plot all except the
last set of data against the left and then the last against the right?

Help!

thanks in advance :)

Bug.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Bugjam1999
 
Posts: n/a
Default


Brilliant! :)

cheers....

Bug.


--
Bugjam1999
------------------------------------------------------------------------
Bugjam1999's Profile: http://www.excelforum.com/member.php...o&userid=26178
View this thread: http://www.excelforum.com/showthread...hreadid=469801

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"