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  

Interpreting Values



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2010, 09:21 PM posted to microsoft.public.excel.charting
mrsatroy
external usenet poster
 
Posts: 7
Default Interpreting Values

I work in a microbiology lab. We test if bugs are Susceptible, Intermediate
or Resistant to a particular antibiotic. In order to make this determination
we look at where a numeric value (we call this an MIC) falls in a set of pre
determined interpretive criteria. I have on a simple chart the number of
samples that obtained a particular MIC, it allows us to see the spread and if
the number heading towards a value that would make them resistant is
emerging. But my question is, can I on the chart show where the column of
samples with a different interpretation to those that have gone before
begins, perhaps a colour change - or a line in the graph area. I know I can
go in and individually change column colours but then can I show on a legend
what each colour means?? Or is there a way to input the interptive criteria??
Hope this makes sense!
--
mrsatroy
  #2  
Old May 27th, 2010, 09:39 PM posted to microsoft.public.excel.charting
mrsatroy
external usenet poster
 
Posts: 7
Default Interpreting Values

I had used the Addline before and while it was a step in the right direction
it didn't fully allow me to interpet the figures based on the pre defined
criteria. Maybe it is just something I can't do in Excel. I had seen a chart
before where it was done but I think it had been done in a stas package and
maybe that is what I need.
Thanks!
--
mrsatroy


"ck13" wrote:

A good website for charts is from Jon Peltier. For your case, you might find
a solution at http://peltiertech.com/Excel/Charts/format.html

This page talk about chart formats. See if the waterfall chart is what you
are looking for. If you are looking for a line, you can see another site of
his http://peltiertech.com/Excel/Charts/AddLine.html

"mrsatroy" wrote:

I work in a microbiology lab. We test if bugs are Susceptible, Intermediate
or Resistant to a particular antibiotic. In order to make this determination
we look at where a numeric value (we call this an MIC) falls in a set of pre
determined interpretive criteria. I have on a simple chart the number of
samples that obtained a particular MIC, it allows us to see the spread and if
the number heading towards a value that would make them resistant is
emerging. But my question is, can I on the chart show where the column of
samples with a different interpretation to those that have gone before
begins, perhaps a colour change - or a line in the graph area. I know I can
go in and individually change column colours but then can I show on a legend
what each colour means?? Or is there a way to input the interptive criteria??
Hope this makes sense!
--
mrsatroy

  #3  
Old May 27th, 2010, 10:51 PM posted to microsoft.public.excel.charting
ck13
external usenet poster
 
Posts: 44
Default Interpreting Values

A good website for charts is from Jon Peltier. For your case, you might find
a solution at http://peltiertech.com/Excel/Charts/format.html

This page talk about chart formats. See if the waterfall chart is what you
are looking for. If you are looking for a line, you can see another site of
his http://peltiertech.com/Excel/Charts/AddLine.html

"mrsatroy" wrote:

I work in a microbiology lab. We test if bugs are Susceptible, Intermediate
or Resistant to a particular antibiotic. In order to make this determination
we look at where a numeric value (we call this an MIC) falls in a set of pre
determined interpretive criteria. I have on a simple chart the number of
samples that obtained a particular MIC, it allows us to see the spread and if
the number heading towards a value that would make them resistant is
emerging. But my question is, can I on the chart show where the column of
samples with a different interpretation to those that have gone before
begins, perhaps a colour change - or a line in the graph area. I know I can
go in and individually change column colours but then can I show on a legend
what each colour means?? Or is there a way to input the interptive criteria??
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 05:16 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.