Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2007 Excel Workbook multiple worksheets I want 1 chart
Dwade -
Others may reply with help for your specific questions, but I have several very general suggestions: Arrange your data in standard list (database) form as you have, but place all data on a single sheet. Use Excel dates (after solving the problem that "Excel always fouls up the time"). Use a pivot table to summarize the data, especially the Group feature for Excel dates. If necessary, use helper columns in your database (e.g., for the "any multiple of months" feature you mentioned). Create automatically-generated pivot charts. - Mike http://www.MikeMiddleton.com "Dwade" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
2007 Excel Workbook multiple worksheets I want 1 chart
I have a final table with all enteries to date. I've had to cut and paste
all the data from all the sheets , into one to get a chart that shows all the data from the beginning of treatment. I know absolutely nothing of pivot tables... maybe it's time to learn but they are very intimidating to me I've never found a way to understand them. I am very much a novice with Excel. The date time function in charts is as far as I've been able to ascertain not cureable as Excel 2007 shows the time portion as 00:00 unless one gets into all types of escoteric language. I spent approximately 14 hours trying to cure that problem and every description or work around is way over my knowledge limit. Not displaying the time in the X axis is NOT acceptable when trying to keep track of unstable blood pressure the time has to show up on the chart. The chart is a cylinder bar chart. Date and time text on the X axis. 3 measurements are on the Y axis. Legend on the right. Limits are set for Y. Minimum 60. Maximum 210. 10 Major. 5 Minor. "Mike Middleton" wrote: Dwade - Others may reply with help for your specific questions, but I have several very general suggestions: Arrange your data in standard list (database) form as you have, but place all data on a single sheet. Use Excel dates (after solving the problem that "Excel always fouls up the time"). Use a pivot table to summarize the data, especially the Group feature for Excel dates. If necessary, use helper columns in your database (e.g., for the "any multiple of months" feature you mentioned). Create automatically-generated pivot charts. - Mike http://www.MikeMiddleton.com "Dwade" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing across multiple worksheets in excel 2007 | Excel Worksheet Functions | |||
How do you format multiple worksheets in 2007 Excel? | Excel Discussion (Misc queries) | |||
Select multiple worksheets in Excel 2007 | Excel Discussion (Misc queries) | |||
my chart worksheets in Excel 2007 are totally blank. Please help | Charts and Charting in Excel | |||
No multiple worksheets when opening with Excel 2007. | Excel Discussion (Misc queries) |