View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Erik Erik is offline
external usenet poster
 
Posts: 96
Default Excel 2003 - Charts - "Data Range" and Date/Time data on X-Axis

Trying to plot data from two colums:
X-Axis: Column 1 is Date/Time (mm/dd/yy hh:mm, e.g. 11/21/06 13:10),
Y-Axis: Column 2 is pH (number to 2 decimal places, e.g. 8.24).

QUESTIONS:
1 - I do not know what DATA RANGE is and not sure what I should be
highlighting/selecting for data range.

2 - Can not get Date/Time data in column 1 to show properly on X axis of
chart...will show date but not time so all points are lumped into one area on
top of each other...number format for chart and data have been changed to be
the same.