Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

graphs and data

ResolvedVersion 2007

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

Wed 29 Apr 2009: Automatically marked as resolved.

Excel tip:

Current date

CTRL+SEMICOLON

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.