View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Dwade Dwade is offline
external usenet poster
 
Posts: 2
Default 2007 Excel Workbook multiple worksheets I want 1 chart

I have Blood Pressure Monitoring series. where

A = Day of Week Month Year as Wednesday Apr 1-09-9:30am this is a text value
not a date as Excel always fouls up the time. Days of the month are 1 - 31 or
1 - 30 or 1-28/29

B= Diastolic Pressure as Number no decimal places

C= Systolic Pressure as Number no decimal places

D= Pulse rate as number no decimal places

I can create a chart for each month. With each month or single for each
month on separate sheet. Each month is formated and arranged the same.

How do I set the chart data range for all months or any multiple of months
14, 2, 3 or 4 or any number of work sheets on separate work sheets, as 1
chart?