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