- Worldstart's Tech Tips Newsletter - http://www.worldstart.com -
Two in One
Posted By On March 17, 2009 @ 3:55 PM In MS Excel,MS Office Help | Comments Disabled
Ever find yourself faced with multiple sets of data in MS Excel?
Did you decide that you wanted them charted together and yet with different types of data representation?
For example, maybe you’d like to see one set of data in a line graph and the other with bars?
If this is your preference then you might be happily surprised to find that you can accomplish this goal – to have a multi-type chart – with just a couple of clicks beyond the creation of your original, single-type chart.
(Yes I know, that creates the chart with both sets in the same graphic form but we’re about to change that.)
These steps should change this:
into something like this:
Voila! Two chart types in one.
Article printed from Worldstart's Tech Tips Newsletter: http://www.worldstart.com
URL to article: http://www.worldstart.com/two-in-one/