Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How can I make a quadruple bar graph on Excel 2007?
My data contains 5 objects that were weighed in different circumstances like in water in salt... I want to put the objects on the X axis and the weight on the Y axis but the objects have to have the different weights graphed.
2 Answers
- Gary ELv 61 decade agoFavorite Answer
Build the data table starting in any cell below Row 1. Enter the object names down the left column of your intended table range. Enter the circumstances across the top row (one row above top object name row and one column right of the object name column. Then fill in the data in the appropriate rows and column.
Next select the entire data table > Chart Tools > Charts: Bar > 2D Bar > Clustered.
If either I or the Chart Wizard guessed wrong on what you want to show in the left side labels, select Chart Tools > Data: Select Data > Switch Row/Column to get the display the way your want.
You are done.
Or you can look around for things to add or change to fine tune the appearance of the chart. It's easy to start over or to use Ctrl-z to back out recent unwanted changes.
Source(s): Tested in Excel 2007