A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel basic chart data layout



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2010, 05:01 PM posted to microsoft.public.excel.charting
Robert H
external usenet poster
 
Posts: 45
Default 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
Ads
  #2  
Old April 29th, 2010, 08:32 AM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
 
Posts: 2,088
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright ©2004-2018 OfficeFrustration.
The comments are property of their posters.