#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
What I am trying to do is plot column "c" from the 3 sheets Nov14,Dec14,Jan15 as one continous plot
|
#5
|
|||
|
|||
I can't see any reason all the data can't be on one sheet.
|
#6
|
|||
|
|||
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.
|
#7
|
|||
|
|||
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.
|
#8
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create a New Sheet from Existing Sheet with Specific Columns | malam | Excel Programming | 1 | 10-17-2014 10:01 PM |
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 |
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 |