Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"Bernard Liengme" wrote in message
... Could you use date&time as the x-values? With your present data, insert a new C column In C1 enter =A1+B1 and format with Custom Format mm/dd/yy hh:mm (or dd/mm/yy hh:mm if Canadian or British) Now make an XY chart with columns B and C. It will look better with more than 4 data points. best wishes from (Old)Bernard -- Bernard V Liengme www.stfx.ca/people/bliengme Thanks for your prompt reply Bernard. Your solution was effectively the same as the "simplified??" description in my original post and thankfully confirmed that I was on the right track! Armed with your confirmation I looked even more closely at my data and realised, for the first time, that some of the time intervals (timestamped automatically by my BP monitor) were well under a minute apart. This explained why some of my chart points were a couple of pixels wider than the norm as the points were being correctly plotted but on top of each other! Manually editing the times to adjacent minute intervals solved my problem. Thanks again for your help. Regards, -- Fred |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Graph - Display Y axis data at top of chart(?) | Excel Discussion (Misc queries) | |||
How do I display the sum of 2 data series on a column chart? | Charts and Charting in Excel | |||
Display a chart only if there is data | Excel Discussion (Misc queries) | |||
Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
How do I display a data table in an Excel 2002 chart? | Charts and Charting in Excel |