Updating Graphs
Dec 7, 2009I have created a series of numbers using a column 'n' and 3 cells for Start value, End value and increment, this is thwe formula: .....
View 9 Replies
ADVERTISEMENT
Automatically Updating Graphs Based On Date?
Jun 9, 2014I have a number of tables which I update on a weekly basis and I've created a number of graphs based on these values, but I only want the graphs to show the previous full months complete data rather than the most recent update. Also, I'd like the graphs to automatically update from the table at the start of each month for the preceding months complete data without me having to re-select the data range each month.
View 1 Replies View RelatedAuto Updating Graphs To Not Include Full Range?
Mar 13, 2014Have been trying to set a chart here to autoupdate which normally is fine to do. In this case however there are other columns in the data table that run down to Dec 2014. Even if i define my needed range, the graph will show the full timeframe (with lots of unneccessary space).
I've attached an example. Rate % is the column that will be updated monthly and I would like the graph to only increment along when a new figue is entered here. I've defined this range as 'Rate' within the sheet.
Multiple Graphs On One Screen And Moving Graphs
Feb 12, 2014i have attached a sheet where I have 4 graphs on one sheet. I prefer this to an overlay. I would like to add a 5th graph but it would make all the the graphs too small. Is there a way to make the graph background longer. For instance, extend the length of this so that I can put multiple graphs on it and then just scroll from top to bottom to review them? Also, how do I copy and paste these individual graphs into a newly created graph. copy/paste doesn't work on these?
Boiler.xls
Batch Changes To Graphs
Mar 20, 2007How can I make batch changes to graphs in the same excel workbook (but on different worksheets?)?
In particular, if I have a bunch of graphs, how can I make bulk changes to color, size, axes titles, etc.?
Seriation Graphs
Nov 21, 2008I'm currently struggling with Excel 2007 and I need to produce a seriation graph. I've searched the web and did a search here and no luck.
Is it even possible to graph data using the a seriation graph in Excel?
If so, How?
Only Showing Certain Graphs?
Dec 18, 2011I am creating a spreadsheet system for storing school grades, and I have a sheet on my system which shows graphs of the students data, and on this sheet there are rather a lot of graphs, and its sort of a visual overload to see so many graphs on one sheet. Im just wondering if there is any thing which I could insert which would give the person using the system a choice of which class's graph they want to show.
View 1 Replies View RelatedColumn Graphs
Mar 16, 2007how do i size column graphs equally? so one graph doesn't look bigger then another... or out of place compared to the other column graphs i have...
View 9 Replies View RelatedWords Into Graphs
Feb 23, 2008I have sort of a weird request. I've got a chart with data on a patient with a sleep disorder and was hoping to create some charts based on the information I've gathered. For example, I've got a column with the amount of time before she falls asleep and another column with a type of food listed. I want to see if there's any correlation between these two variables. What would be the best type of graph to do this, and what formula would I use?
View 9 Replies View RelatedDynamic X Vs Y Graphs
May 3, 2006I am making an excel program that performs a series of complex calculations then produces several charts of the output. I have the output in a table of a known lenght and width. The problem comes when attempting to create the graphs, I first delete all the old graphs and make new ones. Then I try to add the series to the graphs. I want the graph to be one column vs another column but I have only been able to get it to graph a column vs 1, 2, 3, ect.
how to set the x-axis source data for a given series.
Merging Two Graphs
Jun 15, 2006I have two seperate graphs in two different workbooks. Both graph's are identical in the setup, they have the same X axis and Y axis value. They are identical in every way except for the varying in percentages. This graph was originally setup in that it would calculate the results for a period of a week at a time. Is there a way to merge the two graphs thereby showing the results for a two week period?
View 4 Replies View RelatedAutomating Graphs
Jun 30, 2006I'm trying to make alot of graphs(400) and I'm not really sure where to start but here with what I've got so far.
Sub macro2()
Dim x As Long, t As Long, y As Long, z As Long
y = 3
z = 5
x = 4
While x < 1000
With Worksheets("cabernet (2)")
t = Cells(x, 1).Value
Charts.Add
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SetSourceData Source:=Sheets("cabernet (2)").Range("By:Hz"), PlotBy:=xlRows
ActiveChart.Location where:=xlLocationAsObject, Name:="Cabernet (2)"
ActiveWindow.Visible = False
ActiveChart.HasTitle = True
ActiveChart.charttitle.Text = " " & t
Windows("complete Favorite Genes.xls").Activate
y = y + 3
z = z + 3
x = x + 4
End With
Wend
End Sub
I don't really know if putting a variable directly into a range works, so far it doesn't.
As you can tell I need a line graph of the range B3:H5, then the next is the those same columns but 3 rows down, so the next graph is at B6:H8. I'd also like to through in a title here, but I may just be playing with fire. The title is located in column A starting at 4 and corrosponds with each graph, so it too goes is increments of 3, i.e., the first title is at 4 the second at 7 the third at 10. Somebody help me out this isn't working very well at all.
Graphs Using Start And End Times
Jul 8, 2014I have a data which has a start time, end time, Stay Time(End-Start) and # of subjects. I am trying to create a graph, line, bar or histogram which shows how many subjects were there at a specific time. So the horizontal axis would have time from 00:00 to 24:00 and vertical axis would have the total # of subjects or the %.
Start End Subject Stay
01:00 02:00 1 01:00
01:00 01:45 1 00:45
02:00 21:00 1 19:00
03:10 14:10 1 11:00
The data set is huge(27000 rows) and I am using excel to create a graph.
I have tried using line plots and bar charts(stacked) but couldn't. I am not sure if there is an easier way to do it .
Macros For Multiple Graphs
Mar 6, 2007I currently have a 70 page spreadsheet with similar data that needs representing in pie chart format. All the column headers are the same and I only need 2 columns (A and T).
There are however different numbers of rows. Is it possible to write a macro to detect the number of rows before it draws the relevant pie chart (I've managed the pie chart bit!!)
See attached example, same concept but cant post real data.
Copying And Pasting Graphs
Feb 16, 2009I have a graph, that I would like to be able to copy from one sheet and paste into another, is there away of doing this without dropping the data i.e. every time I copy and paste the graph clears, I don't want to copy the spreadsheet data as well as the graph is purely for a visual
View 3 Replies View RelatedGenerating Data For Graphs
Aug 12, 2009I'm knocking up a spreadsheet that deals with expense claims for a small company. Under the Reason column you pick an expense type from a drop down list. What I'd like to be able to do is to set up a graph or table that can identify how much is spent on the different things. As there is a drop down menu system I'd like the worksheet to be able to differentiate the expense types and generate a total balance for each. Enclosed is an example of the spreadsheet.
View 2 Replies View RelatedMacro To Create A PPT Of Graphs
Apr 24, 2014I have this following code to create the PPT with a specific template. But in this, the first slide of the PPT are coming blank. How to remove those blank slides?
PHP Code:
Sub CreatePowerPoint()Answer = MsgBox("Are you sure you want to continue?" & vbNewLine &
"Clicking 'YES' will create the DU Dashboard PPT" & vbNewLine & "You may want to set the range & Update VOC graph",
vbYesNoCancel + vbInformation, "Warning: DU Dashboard graph")If Answer = vbYes Then Else Exit Sub
'Add a reference to the Microsoft PowerPoint Library by: '1. Go to Tools in the VBA menu '2. Click on Reference
[Code]...
Add Graphs From Workbooks To Powerpoint
Feb 21, 2014So I have lets say 3 workbooks and on each first tab of that worbook there is a (pivot)graph. Now what I would want is VBA code which opens these excel workbooks, then copy the chart and paste it into a powerpoint presentation each chart on a new powerpoint slide. So it can be rather basic. A loop which goes thru excel sheets and always takes the chart on the first tab. I see a lot of different code but not what I really can use for powerpoint thru excel vba.
View 2 Replies View RelatedPivot Tables With Graphs
Mar 13, 2014I have a 8 pivottables with a graph for each. is there a way that i can have a dropdown menu to select which graph to display instead of having all these graphs everywhere....
View 4 Replies View RelatedMacro To Update Graphs
Oct 11, 2008I have multiple graphs that read from rows varying in length from 2 to 60 columns long, depending on user input. I need help in creating a macro that readjusts the graphs to read from smaller/larger data set.
I created one that said: If user input = 1, then set graph to (A1:A1), If user input = 2, then (A1:B1), but this is really inefficient. Is there a better way?
Change Graphs To Pictures In VB
Mar 15, 2009My macro suppose to loop on every charts in the workbook and change them to pictures , I'm using the Pastespecial method to do it but sometimes I'm getting a 1004 error in the line that do the paste command. Is there is a better way to do it? ..........
View 11 Replies View RelatedConditional Formatting With Graphs
Mar 20, 2009I have a document that is a question and answer (an audit check sheet). Based on how the questions are answered, I need to have a bar within a graph change colour.
Is this possible ? Im not sure if we can use conditional formating or programming to amend a graph.
Would i need to use conditional formatting or vba/macro ?????
I have attached the document with a more detailed outline.
VBA Copying Multiple Graphs
Jan 4, 2012I am trying to copy a group of six graphs from one Sheet "Charts" and paste them in another Sheet "FinShots" in the same Workbook. I have grouped the graphs and named the group "FinShots1".
But I can't seem to write a code that will copy group "FinShots1" from "Charts" and paste in "FinShots".
Multiple Graphs In Excel Using VBA
Apr 3, 2012I am currently working through data received from several experimental runs I have done for my masters studies (In chemical engineering). I need to create a chart for every experiment but coding the macro to do that has been near impossible. I have the file with the first graph drawn but I dont know how to post it.
I know it will be possible to draw every chart by hand but I am waiting on another 300+ data sets and then the amount becomes crazy.
Matching Y Axis Of Graphs?
Jun 18, 2014I have two graphs, graph 1 and graph 2.
The y-axis of graph 1 is set to Auto.
My question: is there anyway to get graph 2's y-axis to change to whatever graph 1's y-axis is automatically?
Conditional Formating On Graphs
Jun 10, 2006if its possible to run conditional formating on graphs, I can do this fine on the actual data
i.e. Have a bar chart with a number of bars all the same colour and just wanted to have the bars change to red if they drop below a certain percentage.
only running excel 2000
Grouping Worksheets With Graphs
Jul 11, 2006Is there a handy way to group worksheets withing a workbook, other than hiding them? I'm building a workbook at the moment and am constantly adding worksheets and expect a lot more when producing graphs. I have in mind a tab that would say for example "graphs" and when selected it would free up or open all the graph worksheets and when not in use all those worksheets could be grouped together behind that one tab.
View 5 Replies View RelatedMacro For 3000+ Graphs
Aug 25, 2006I need to create a macro to create 3000+ graphs (maybe not necessarily all in the same worksheet or workbook). I have code for what I would like the graphs to look like:
Option Explicit
Sub OzgridExample()
Charts.Add
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SetSourceData Source:=Sheets("Data Sheet"). Range("C7:G7"), _
PlotBy:=xlRows
ActiveChart.SeriesCollection(1).XValues = "='Data Sheet'!R3C1:R3C7"
ActiveChart.Location Where:=xlLocationAsObject, Name:="Data Sheet"
With ActiveChart ..................
Linking Graphs From Excel To PowerPoint (Only Once)
May 6, 2014I have an excel that gets updated monthly for reporting. The goal is to get the graphs to update automatically by linking them from excel into power point. This is relatively easy but what when I go to update the report for the next month the data for the old power point changes as well. Is there a way to prevent this?
View 1 Replies View RelatedExcel 2012 :: Bar Graphs With Two Different Axis
Jan 6, 2014Excel 2012 user.
I am trying to create two vertical axis bar graphs with the Primary axis for period Q1 to Q4 and the secondary axis for FY. I have attached what I have done so far and have successfully converted all but one FY bar graph to secondary axis. Once I try to select the last one (dark gray bar called "2011 FY" on the very far right), the FY bars disappears.
My main purpose is to get both Q1-Q4 & FY on the same graph and the reason I plotted FY on the secondary axis is because I didn't want the FY $ scale to massively skew the entire graph.
Sample Report 06JAN14 - Bar graph with two axis.xlsx