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  

Defining areas on a graph



 
 
Thread Tools Display Modes
  #1  
Old April 19th, 2010, 03:59 PM posted to microsoft.public.excel.charting
mrsatroy
external usenet poster
 
Posts: 7
Default Defining areas on a graph

I am working in a microbiology lab and am plotting on a bar chart zone size
versus number of isolates. The size of the zone determines whether or not an
organism is sensitive, intermediate or resistant to an antibiotic. I would
like to be able to illustrate on the graph which area on it pertains to
resistance/intermediate/sensitive. At the moment I just have a list of the
zone sizes on the Y axis but it would be great if there was a visual
representation on the chart area of where the different interpretations began
and ended, inother owrds to almost divide the graph into 3 areas with the
columns in each area. Hope this makes sense!
--
mrsatroy
  #2  
Old April 19th, 2010, 04:42 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 516
Default Defining areas on a graph

How about adding horizontal lines to denote the boundaries?
Could use one of these methods:
http://peltiertech.com/Excel/Charts/...orzErrBar.html
http://peltiertech.com/Excel/Charts/...orzSeries.html
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"mrsatroy" wrote in message
...
I am working in a microbiology lab and am plotting on a bar chart zone
size
versus number of isolates. The size of the zone determines whether or not
an
organism is sensitive, intermediate or resistant to an antibiotic. I would
like to be able to illustrate on the graph which area on it pertains to
resistance/intermediate/sensitive. At the moment I just have a list of the
zone sizes on the Y axis but it would be great if there was a visual
representation on the chart area of where the different interpretations
began
and ended, inother owrds to almost divide the graph into 3 areas with the
columns in each area. Hope this makes sense!
--
mrsatroy


 




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 12:57 PM.


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