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.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

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.13 secs.