A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combining a 2-D column graph and a 2-D line graph on the same char



 
 
Thread Tools Display Modes
  #1  
Old February 21st, 2010, 06:32 PM posted to microsoft.public.excel.charting
Filippo
external usenet poster
 
Posts: 5
Default Combining a 2-D column graph and a 2-D line graph on the same char

I would like to show a 2-D column graph and a 2-D line graph on the same chart.
The independent variable on the X-axis (name of employee) is the same for
both graphs.
The dependent variables on the y-axis are different:
(1) years of experience (column graph), (2) cumulative years of experience
(line graph).
I need to use two different scales for the y-axis to make both graphs
visible, as the year of experience of the employees ranges between 1 and 40
years and the cumulative years of experience ranges between 1 and 1500 years.
The input data for the graphs are listed in three columns of a single
worksheet.
Could anybody make a suggestion about how to combine the graphs?
Many thanks
Filippo
  #2  
Old February 21st, 2010, 07:54 PM posted to microsoft.public.excel.charting
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Combining a 2-D column graph and a 2-D line graph on the same char

I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 69 towards the top of my home page.

The only thing I have changed from what you want is how you have structured
your underlying data. I have done it slightly differently (see Completed
_Chart Worksheet cells A 1 to G 3. You may, therefore, have to adapt your
method of working to what I have done.

Apart from that I think the chart does what you want it to do.

If my comments have helped please hit Yes.







"Filippo" wrote:

I would like to show a 2-D column graph and a 2-D line graph on the same chart.
The independent variable on the X-axis (name of employee) is the same for
both graphs.
The dependent variables on the y-axis are different:
(1) years of experience (column graph), (2) cumulative years of experience
(line graph).
I need to use two different scales for the y-axis to make both graphs
visible, as the year of experience of the employees ranges between 1 and 40
years and the cumulative years of experience ranges between 1 and 1500 years.
The input data for the graphs are listed in three columns of a single
worksheet.
Could anybody make a suggestion about how to combine the graphs?
Many thanks
Filippo

  #3  
Old February 22nd, 2010, 12:20 AM posted to microsoft.public.excel.charting
Filippo
external usenet poster
 
Posts: 5
Default Combining a 2-D column graph and a 2-D line graph on the same

Your reply answers the question as posted. I re-arranged my data and placed
them in the Excel file downloaded from your website. The two graphs were
plotted correctly on the same graph.
However, my actual task is a little more complicated. In addition to 'years
of experience' and 'cumulative years of experience' I need to plot 'years
with the company' (column graph) and 'cumulative years with the company'
(line graph). The chart will actually contain four graphs. The two line
graphs use the same scale on the right side of the chart and the two column
graphs use the same scale on the left of the chart.

I guess my questions are how can I add a graph to an existing chart and how
can I select the type of graph and the scale.

Many thanks for your help and sorry for asking an additional question!

Filippo


"trip_to_tokyo" wrote:

I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 69 towards the top of my home page.

The only thing I have changed from what you want is how you have structured
your underlying data. I have done it slightly differently (see Completed
_Chart Worksheet cells A 1 to G 3. You may, therefore, have to adapt your
method of working to what I have done.

Apart from that I think the chart does what you want it to do.

If my comments have helped please hit Yes.







"Filippo" wrote:

I would like to show a 2-D column graph and a 2-D line graph on the same chart.
The independent variable on the X-axis (name of employee) is the same for
both graphs.
The dependent variables on the y-axis are different:
(1) years of experience (column graph), (2) cumulative years of experience
(line graph).
I need to use two different scales for the y-axis to make both graphs
visible, as the year of experience of the employees ranges between 1 and 40
years and the cumulative years of experience ranges between 1 and 1500 years.
The input data for the graphs are listed in three columns of a single
worksheet.
Could anybody make a suggestion about how to combine the graphs?
Many thanks
Filippo

  #4  
Old February 23rd, 2010, 01:34 AM posted to microsoft.public.excel.charting
AdamV[_2_]
external usenet poster
 
Posts: 38
Default Combining a 2-D column graph and a 2-D line graph on the same

As long as your data is a new series for the existing categories
(employees or teams or whatever), then you can simply select the new
range of data, copy (Ctrl-C or ribbon button) and then select the chart
and paste.
You can do this for new categories or new series, as long as they match
existing ones in size.

Now, after pasting your two new series you need to format each one and
choose to plot it on the primary or the secondary axis, depending on
which scale you want that one to have. You can only have two axes
maximum so you don't need to find a way to control the scale.

For each series you can simply right click and go to Change chart type
(in 2007 at least - you don't seem to say what version you are using?)

Hope this helps
Adam

On 21/02/2010 23:20, Filippo wrote:
Your reply answers the question as posted. I re-arranged my data and placed
them in the Excel file downloaded from your website. The two graphs were
plotted correctly on the same graph.
However, my actual task is a little more complicated. In addition to 'years
of experience' and 'cumulative years of experience' I need to plot 'years
with the company' (column graph) and 'cumulative years with the company'
(line graph). The chart will actually contain four graphs. The two line
graphs use the same scale on the right side of the chart and the two column
graphs use the same scale on the left of the chart.

I guess my questions are how can I add a graph to an existing chart and how
can I select the type of graph and the scale.

Many thanks for your help and sorry for asking an additional question!

Filippo


"trip_to_tokyo" wrote:

I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 69 towards the top of my home page.

The only thing I have changed from what you want is how you have structured
your underlying data. I have done it slightly differently (see Completed
_Chart Worksheet cells A 1 to G 3. You may, therefore, have to adapt your
method of working to what I have done.

Apart from that I think the chart does what you want it to do.

If my comments have helped please hit Yes.







"Filippo" wrote:

I would like to show a 2-D column graph and a 2-D line graph on the same chart.
The independent variable on the X-axis (name of employee) is the same for
both graphs.
The dependent variables on the y-axis are different:
(1) years of experience (column graph), (2) cumulative years of experience
(line graph).
I need to use two different scales for the y-axis to make both graphs
visible, as the year of experience of the employees ranges between 1 and 40
years and the cumulative years of experience ranges between 1 and 1500 years.
The input data for the graphs are listed in three columns of a single
worksheet.
Could anybody make a suggestion about how to combine the graphs?
Many thanks
Filippo

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:29 PM.


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