I started keeping some charts and I don't know how to do one thing...

I have my values for the standard X and Y axis data, but I want another set of data to show as just a vertical line. In the example you can see that the series is a bunch of dates with blood test results for each date marked.

The second set of data is shown as just a vertical line and indicates when more blood was given. The line is just drawn in... As the chart grows, the line moves away from the correct date and is useless. I don't want the series plotted from date to date, just that each time it happens a tick mark or vertical line shows up.

Anyone know a way to get another series of data to do something like that? Or even know what I mean?

chart2.gif
Description:
Filesize:	8.53 KB
Viewed:	9386 Time(s)

Last edited by Doctor Feelgood on Sat, 01 Sep 2007 09:07:47; edited 1 time in total

i'll look into it
_________________
- Jim

Anything?

I can run a buffer overflow attack against excel if that'll help ya???

Sorry I'm really not that good with Excel.

Dr. EvilCheeze wrote:

I can run a buffer overflow attack against excel if that'll help ya???

oh yeah, that would be great! and almost the same end result.

I keep updating this chart, and my vertical line moves on down the line each time...

*Edit - Never mind... took another sip of coffee and realized what I said... carry on.

Maybe I won't need help! I wanted to know how to do this in order to plot not only my blood test results versus the date, but to also have the third value of transfusion dates indicated on the chart.

Well, it has been about 6 weeks since my last transfusion, and the need for that extra value to be shown isn't so important.

While my values are still terrible, they reduced the threshold of where I used to receive a transfusion from 20 down to 10, so it doesn't look like I'll be making any vertical lines on the chart any time soon.

chart2.gif
Description:
Filesize:	7.82 KB
Viewed:	8978 Time(s)

If you know that your (realistically) highest Y-value is going to be 144k platelets/microliter, than you can make a vertical line stick using the following method. Note that this is assuming you used a scatter plot, which it appears like you did.

Create a second data "set" of one point.

The x-value is the date you want.
The y-value is going to be ~144, or what you would expect your highest y-value to approximately be.

Now, add this point as another series in your chart (Right click chart --> source data).

The point should show up on your graph. Right click on it and select "Format Data Series", then "Y-error bars". Choose "Display minus", and percentage "100%". Click OK.

You should now have a linked, dynamic vertical error bar with the date you want. You should just be aware that it might get smaller or non-visible if your maximum y-value changes (you should see what I mean when you try it if you don't understand why).

By the way, what is 144k/ul? Is that the average level or your individual goal? Good luck as always. - Cleem

Thanks for the help Cleem - I'll give that a shot.

I guess 144 would be a goal. That is the minimum value to be considered healthy, as the healthy range is 144-400. I obviously have a long way to go!

Doctor Feelgood wrote:

Thanks for the help Cleem - I'll give that a shot. I guess 144 would be a goal. That is the minimum value to be considered healthy, as the healthy range is 144-400. I obviously have a long way to go!

You're welcome boss. And don't give up hope, maybe in time stem cell research will get to the point where you can be injected with new adult MSCs that differentiate into platelet producing machines. We'll fix you.