Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-09-2015, 02:50 PM
milo milo is offline Display more than one sheet in a graph Windows XP Display more than one sheet in a graph Office 2010 32bit
Novice
Display more than one sheet in a graph
 
Join Date: Jan 2015
Posts: 4
milo is on a distinguished road
Default Display more than one sheet in a graph

I want to graph across aprox 40 sheets, anyone kn ow how to do this?



This is a partial formula (start small) but it is rejected, but will work with other functions like sort ect.

('nov14'!$C$2:$C$31,'dec14'!$C$2:$C$32,'jan15'!$C$ 2:$C32

Any help?

Tia

Milo
Reply With Quote
  #2  
Old 01-10-2015, 01:48 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Display more than one sheet in a graph Windows 7 64bit Display more than one sheet in a graph Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
there are numerous examples out there. One of them can be found at http://peltiertech.com/Excel/ChartsH...iffSheets.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 01-10-2015, 11:57 AM
milo milo is offline Display more than one sheet in a graph Windows XP Display more than one sheet in a graph Office 2010 32bit
Novice
Display more than one sheet in a graph
 
Join Date: Jan 2015
Posts: 4
milo is on a distinguished road
Default Chart iover many pages

I did not see anything over multi pages, here is a test file I want to plot columns A and C as a minimum. A being on the bottom, C on the other.

Thanks in advance with any help.
Attached Files
File Type: xlsx test.xlsx (58.1 KB, 11 views)
Reply With Quote
  #4  
Old 01-12-2015, 12:21 PM
milo milo is offline Display more than one sheet in a graph Windows XP Display more than one sheet in a graph Office 2010 32bit
Novice
Display more than one sheet in a graph
 
Join Date: Jan 2015
Posts: 4
milo is on a distinguished road
Default

What I am trying to do is plot column "c" from the 3 sheets Nov14,Dec14,Jan15 as one continous plot
Reply With Quote
  #5  
Old 01-12-2015, 04:59 PM
gebobs gebobs is offline Display more than one sheet in a graph Windows 7 64bit Display more than one sheet in a graph Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I can't see any reason all the data can't be on one sheet.
Reply With Quote
  #6  
Old 01-13-2015, 10:48 AM
milo milo is offline Display more than one sheet in a graph Windows XP Display more than one sheet in a graph Office 2010 32bit
Novice
Display more than one sheet in a graph
 
Join Date: Jan 2015
Posts: 4
milo is on a distinguished road
Default

because after line 32 (not in sheet I posted) I do a bunch of sub totals and averages and other stuff for each month. Otherwise it could just go on forever on one sheet.
Reply With Quote
  #7  
Old 01-13-2015, 12:48 PM
gebobs gebobs is offline Display more than one sheet in a graph Windows 7 64bit Display more than one sheet in a graph Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by milo View Post
because after line 32 (not in sheet I posted) I do a bunch of sub totals and averages and other stuff for each month. Otherwise it could just go on forever on one sheet.
Sure, but you can always do subtotals having filtered for specific dates or you can have another table which pulls the totals for the periods you want. IMHO, it would be more robust. I can work up a quick illustration if you like.
Reply With Quote
  #8  
Old 01-13-2015, 04:02 PM
gebobs gebobs is offline Display more than one sheet in a graph Windows 7 64bit Display more than one sheet in a graph Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Just for the halibut , check the attached out. Currently, it is filtered just for December '14. You can change the filtered range by clicking the little filter icon to the right of the Date header. Last week, last month, last quarter, last year, specific months, etc. etc.

Ignore the column headings that were added. This is done automatically when you use the Format as Table function. This function makes managing equations (and a lot of other things) really easy and logical. You can rename them if you like.

Also, I only copied the data from your tables, not the formulas. Some had reference errors anyway. So this is, as I said before, just for illustration.

On the Summary tab are all your metrics. I've only done a few, but am confident the others can be done to once the fields are defined. First, the start and end filtered dates are displayed, 12/1/14 and 12/31/14. These will change automatically if you change the date filter.

Then is Total Readings, ... , Median are calculated. Again, just for the filtered data. I don't know what the other metrics are so I didn't enter any formulas.

Look at the formula for Filtered start...
=SUBTOTAL(105,AllData[Date])

Subtotal is a formula that does certain functions only over applied filtered data. 105 is the code for Minimum. So this formula says, in effect, find the minimum for the filtered table for the data in the Date column of the AllData table. Like the column headings, you can change the name of the data table to suit your liking. Any of these changes will be reflected in the equations automatically. Neat huh?

Now go to the Chart tab and there is your plot for Data1 and Data2. Like the metrics, the chart will display all data within the filtered dates.

I tried to see if there was any way to make a continuous plot of data over multiple tabs, but it doesn't appear to be possible as far as I can tell.
Attached Files
File Type: xlsx testthis.xlsx (37.3 KB, 7 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display more than one sheet in a graph Create a New Sheet from Existing Sheet with Specific Columns malam Excel Programming 1 10-17-2014 10:01 PM
Display more than one sheet in a graph column clustered bar graph with a line graph as secondary axis Alaska1 Excel 2 06-09-2014 07:13 PM
Priority of line graph vs bar graph in terms of front to back positioning on a chart DavePPointuser PowerPoint 1 04-30-2014 10:57 AM
Display more than one sheet in a graph how to display Timestamp on x-axis in Scatter smooth line graph bugserm Excel 1 01-23-2012 02:28 AM
paste graph between workbook/sheet sandsoppa Excel 2 02-25-2011 02:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft