Joanne has attended:
Excel Advanced course
Graphs and Data
How can include a bar graph and a line graph in one graph using two or more sets of data?
RE: Graphs and Data
Hi Joanne. If each series of data is similarly scaled then you just need to right click on each series on your graph and select a different chart format for each. If the scales are vastly different, you can set up a second axis on the right hand side of the chart (Format Data Series - Axis and choose secondary axis), and format that scale accordingly. You can have a number of different chart types on the same graph, but you are limited to two axes.
Hope this helps,
Anthony