LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Val Val is offline
external usenet poster
 
Posts: 32
Default comparison line graph help needed

I am trying to chart two sets of data on one chart. The data sets will come
from sheets within the same spreadsheet.

Both sets use dates, but they might be different dates, so I'd like to have
the x axis show consecutive dates (e.g 1-1-10 through 1-31-10)

The y axis in both cases will be time of day. I want to display time by
hourly increments for 24 hours on this axis.

I want the chart to show times medication is administered (from sheet 1)
and times a specific event occurs (from sheet 2)

I have been trying for hours and getting nowhere. I generally chart using
bars, but did not think this would be so different.

Help, please.

Val
 
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
How to convert a dotted line to a solid line in a line graph Sharlz Charts and Charting in Excel 1 January 14th 09 04:51 AM
How do I do scatter graph comparison examgirl Charts and Charting in Excel 1 December 26th 08 10:57 PM
Comparison graph in excell Anisa Charts and Charting in Excel 1 September 6th 07 02:07 PM
Markers only appearing on comparison line graph [email protected] Charts and Charting in Excel 1 September 1st 06 06:13 PM
Comparison / Check Off between 2 excel sheets. HELP NEEDED! sax30 Excel Worksheet Functions 8 April 28th 05 09:13 AM


All times are GMT +1. The time now is 02:44 AM.

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"