98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Graphs and Data
Graphs and Data
Resolved · Medium Priority · Version 2007
Wed 22 Apr 2009, 15:57Delegate Joanne said...
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?
Wed 22 Apr 2009, 16:24Trainer Anthony said...
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Select only cell that contain text to lock formatFor selecting cells that only contain Text in Excel |
