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

  • Thread starter Thread starter Filippo
  • Start date Start date
F

Filippo

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
 
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.
 
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
 
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
 
Back
Top