Excel Chart Question

[shelby55]

Hi

I am working with Excel 2002.

I have a chart showing number of time from triage to physician assessment on the x axis and # of numbers on the y axis.

I would like to show a bar/line of different colour for the 90th percentile - is this possible to program in or do I have to just draw it after calculating it?

Also, is there a way to use the triage to physician time in hours left as hours or do I need to convert to text?

Thanks.

 

[JPaules]

It is possible to have a line that's separate from the other data. I did it myself but I'm not sure if I can clearly explain how.

I have one set of data that gives me columns (number of audits) submitted. They have to submit a 2 audits a week so I have a dynamic line that shows where they need to be as of a certain date. That calculation is charted as a line. Both charts are located on the same worksheet and use the same Y axis.

Is that kind of what you're looking for? If it is, I'll see if I can find the site that walked me thru the setup.

--
JP

 

[JPaules]

http://peltiertech.com/Excel/Charts/ComboCharts.html

Try this site.

--
JP

 

[SkipVought]

Hi,

It's just another series -- all with the same value.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[shelby55]

Hi

Thanks very much but I'm still confused.

The x axis is the various times in hours for the triage to PIA time. The cases column is cases. So for the 90th percentile value, do I add a column and only include a value for total cases in the hour of 2.6 hours (the 90th percentile figure)?

If not then what do I do? Thanks.

 

[JPaules]

I was envisioning time as the Y axis. Let me back up a bit (okay, way back)...What exactly are you trying to illustrate with the chart?

--
JP

 

[SkipVought]

In your source data, I'm guessing that you have a column for your x-values (time) and a column for your y-values.

Just add another column and have the 90th percentile value in that column -- SAME value in each cell.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}