If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel basic chart data layout
I’ve just been upgraded to Office 2007 and trying to get data were I
want in a basic chart is surprisingly difficult. I have a table with three columns; Potential Hazards, Severity and Probability I want a column chart with Probability in the X axis, Severity in the Y axis and the corresponding Potential Hazards in the legend. I could use some basic direction as to how to accomplish this. Thanks Robert |
#2
|
|||
|
|||
Excel basic chart data layout
Hi,
Can we assume the problem you are having is the chart contains 3 series rather than 2. With the first series being the information you require as the horizontal axis labels. If so the simplest fix is to remove the text description from the top of the first column, "Potential Hazards". If none of the columns contain header labels then try adding text to the top of the last 2 columns. This will help Excel to guess your data layout, as currently all 3 appear suitable to use as data series. Cheers Andy On 28/04/2010 17:01, Robert H wrote: I’ve just been upgraded to Office 2007 and trying to get data were I want in a basic chart is surprisingly difficult. I have a table with three columns; Potential Hazards, Severity and Probability I want a column chart with Probability in the X axis, Severity in the Y axis and the corresponding Potential Hazards in the legend. I could use some basic direction as to how to accomplish this. Thanks Robert -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|