Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use 'names' in defining a series in a graph | Charts and Charting in Excel | |||
Shading areas in a graph | Excel Discussion (Misc queries) | |||
Excel 2007 defining names (areas) | Excel Worksheet Functions | |||
Defining specific areas for users to enter data | Excel Discussion (Misc queries) | |||
Graph with shaded/colored Areas?? | Charts and Charting in Excel |