LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Chart help - cannot display all data

Excel 2000

At various times during each day I have to measure my blood pressure. Each
time I take 4 readings (simplified version).

A: DATE B: TIME C: BP
A1: 01/01/2007 B1: 09:00 C1: 75
A2: 01/01/2007 B2: 09:01 C2: 77
A3: 01/01/2007 B3: 09:02 C3: 74
A4: 01/01/2007 B4: 09:03 C4: 77

I can generate a scatter chart with Days on the x axis, BP on the y axis and
the C data as vertical columns of short horizontal lines ( - ) for each day.

This method produces a good graphical representation of the range of the
day's readings, but multiple readings with the same value are only displayed
as a single point on the chart.

i.e. 1 off 74, 1 off 75 and 1 off 77

I still need to create a chart that will display every reading so I tried
using a helper column D with the values A+B i.e.

D1: 39083.375
D2: 39083.37569
D3: 39083.37639
D4: 39083.37708

I then used these values for the x axis and series range but this only
worked over a minute spread of D values before, once again, failing to
display multiple values correctly.

Quite probably a "senior moment", but any help would be greatly appreciated.

--
Fred


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graph - Display Y axis data at top of chart(?) Suzanne Excel Discussion (Misc queries) 5 March 21st 07 09:13 PM
How do I display the sum of 2 data series on a column chart? Sergrock Charts and Charting in Excel 1 August 25th 06 09:05 AM
Display a chart only if there is data duncanslam Excel Discussion (Misc queries) 4 July 5th 06 10:20 AM
Can I display the actual data in the data field of a pivot chart? Tom Pivot! Excel Discussion (Misc queries) 1 January 12th 06 05:10 PM
How do I display a data table in an Excel 2002 chart? Dr. Mark F. Charts and Charting in Excel 3 December 29th 04 03:04 PM


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"