View Single Post - Excel Question

Cleem · Rated PG-13

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