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

"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
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 05:29 PM.

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

About Us

"It's about Microsoft Excel"