In the following macro, how to get the name of the chart as the slide title?
PHP Code:
Sub Range_Chart_1()
'Requires a reference to the Microsoft PowerPoint Library via the Tools - Reference menu in the VBE
Dim PPApp As PowerPoint.Application
Dim PPSlide As PowerPoint.Slide[code]....
What can I do with this data?
In the year 2004 I designed and built my own solar hot water heater box. It works very well and saves me and my family a lot of money every month.
To understand what was going on inside and out of the heater box I purchased a commercial interface unit that consists of a circuit board interfaced to my computer via a serial cable. There is also suitable software provided by the supplier which appears to be a Visual Basic programme or something similar.
The circuit board interfaces eight sensors. These are defined as:- Input (Zero), 3.9 M, 7.8 M, 11.7 M, 15.6 M, Outlet, Internal air and External Air. The metre distances occur by dividing the entire length of the water pipe into equal distance between Inlet and Outlet.
Once the software is set up and "started" it automatically dumps the data (which I record at five minute intervals) into an EXCEL Add-in file. At the end of a day I save the Excel file and then manipulate the data into a chart which gives a picture display of all the sensors and the temperatures recorded.
I have attached a typical Excel file for one day. I try to record most days, but if the weather is overcast and no sun appears there is little or no point in recording.
I am already au-fait on how to use Excel for Min and Max temperatures and chart creation, but I would like to ask everyone how I can add a slide bar to the top of the graph to show temperature readings?
People who read this forum thread should note that once the sun starts rising (around 08.30am) then the water in the solar heater rises dramatically. This can be seen on the attached chart.
I'm looking for the below requirement:
Name
Date
Sales1
Sales2
Daniel
01/18/11
4,907.00
2,038.00
[Code] ..........
Required output....
Name
Date
Sales1
Sales2
Name
Date
Sales1
Sales2
[Code] ......
Need macro code to segregate the data...
For the chart in the excel worksheets, does anymore know who to copy it to the powerpoint slide with VBA? (either straight copy and paste, or copy and paste in as picture?)
View 4 Replies View RelatedWhich the best procedure to copy a chart into a powerpoint slide from a excel workbook? So that when I update the chart data in the excel workbook I can update it even in the powepoint slide ....
View 1 Replies View RelatedI'm using concatenate to name a chart title. My problem is that when I concatenate two dates I lose the date format. I'm after a title which looks like 06 December 2007 - 13 December 2007
I'm actually getting 39422 - 39429
The cells have been formatted in date format but lose this when concatenated.
Is there a sollution?
I have a pivot table which I update on a regular basis. There's also routine during the pivot table refresh to assign variables to the minimum and maximum dates I include in the range.
Here's what I'm looking for - The chart title needs to be two separate lines. It should look something like this:
Labor Operations performed from min_date to max_date
(labor op code, description, total ops)
By themselves, I have no problem doing this. What I can't figure out is how to format the font of the first line of the title to have different characteristics from the second line. The second line is sort of a descriptor of the part in bold (in an attempt to keep my boss from asking me questions about what he's looking at)
Is there a simple way (without writing code) to have a chart title equal the file (workbook) name? For example a formula to write in the 'Chart Options' 'Chart Title' box?
View 7 Replies View RelatedI am creating many graphs. I have already split my data so I can use CurrentRegion.I want each graph to have a different title using the text value of a cell which would be (6 * j - 5, 2) inside the For/To, but I can't get it to work no matter how much I tinker.This is the code as is without any of my attempts inside to clutter it up.
VB:
Dim p As Long p = Sheets("ForWeb").UsedRange.Rows.Count For j = 1 To (p - 1) / 4 ActiveSheet.Shapes.AddChart.Select ActiveChart.ChartType = xlLine ActiveChart.SetSourceData Source:=Cells(6 * j - 5, 5).CurrentRegion ActiveChart.Parent.Cut Cells(6 * j - 5, 1).Select ActiveSheet.Paste Next
c5 shows today() and I'd like c5.value to be the headline of a chart. Hence, in sample file the headline be changed to 05/03/2014 (and tomorrow to 06/03/2014..).
View 2 Replies View RelatedHow do i change a title in legend on a chart. i.e. I want the label to be MGRS 2%
Job Category
Category %
EE Total
Mgrs
2%
15
Supvr
6%
51
[code]....
I've found several threads describing how to make a chart title dynamic by entering a cell reference into the formula bar with the chart title selected. I am wondering if anyone knows if it is possible to have VBA "code" a formula into a chart title that would be a concatenation of several strings. Ideally, I'd like to specify part of the title from a variable, and another part from a user-specified range, as in the following snippet from a module of mine:
ChartSubtitleText = Sheets("Sheet1").Range("A5")
ActiveChart.ChartTitle.Select
Selection.Characters.Text = ChartTitleText & Chr(10) & ChartSubtitleText
where ChartTitleText is a string variable that is passed to the Sub. This works fine and correctly builds the title block during execution of the macro, but I'd like to modify the capability to allow the user to enter a new value in Sheet1!A5 and have all of the charts update dynamically without re-executing the macro. Is there a way to have VBA create the chart and build the Chart Title with a formula that will allow for dynamic updating? I've tried having it enter the following line into the formula bar, but get errors: =CONCATENATE(ChartTitleText, CHAR(10), Sheet1!A5)
I have a very simple template which plots out means and standard errors of a treatment structure. The input is from an analysis of variance so I want to have the significance levels dispalayed in the title. This is simple for a single col of data but when there are more then one it doesn't use a cell to populate the chart title.
From the sheet I've attched the first and second chart have dynamic titles, if you change cell F10 from 0.364 to 0.001 the title on the second chart will change to "Input (**)" as it uses M19 for the title. The problem is that for the 3rd chart titled "CV*TR (NS)" any change has to be done manually (change cell F15 to 0.04 and this changes cell J43 to "CV*TR (*)".
example.xlsx
How do I put a title on my chart, I'm using 2010 excel for mac.
View 2 Replies View RelatedI have a program that updates values quarterly when run. The spreadsheet that it works with also contains a couple of pie charts that correspond to the updated data. the charts only have one series with category values. I recorded a macro to see the code excel uses for creating a new chart and tried to modify the statements to my needs but have been running into runtime error 1004 ("Method ' Cells' of Object '_Global' failed"). The code is as follows I don't have any trouble until the last two statements.
Sub Chart_Updater()
Sheets(Chart1var).Select
With ActiveChart
.HasTitle = True
If Chart1var = "COLI VUL 1 Fund Chart" Then
.ChartTitle.Text = "COLI VUL 1 Allocation by Fund Provider " _
& sday & "-" & sday & "-" & Lyear
ElseIf Chart1var = "COLI VUL 2 Fund Chart" Then
.ChartTitle.Text = "COLI VUL 2 Allocation by Fund Provider " _
& sday & "-" & sday & "-" & Lyear
ElseIf Chart1var = "COLI VUL 7 Fund Chart" Then
.ChartTitle.Text = "COLI VUL 7 Allocation by Fund Provider " _
The variables fundtr1, fundtr2, and emptycolvar are public, and are all returning values, so there is no problem there. Also I can't use ranges like "A1:F7" because the range needs to be variable.
Is it possible to update Chart Titles in Batches. For the following Titles:
'Client 1, Jan 07'
'Client 2, Jan 07'
'Client 3, Jan 07'
'Client 4, Jan 07',
Would you be able to change 'Jan 07' to Jan 08' on all of the above whilst keeping the variable client name, in a single batch process?
how to resize the plotarea of a chart so that it wont overlap with the title. I can't seem to find the appropriate property to let me determine the height or the bottom edge of the chart title.
View 2 Replies View RelatedI am having difficulty figuring out how to get my chart title to automatically update when my chart changes via filtered criteria. I can get it to change by clicking the title bar on the chart, but would like the title to automatically update as soon as I select new criteria and the chart changes.
View 9 Replies View RelatedWhy the heck every time I enter in to the "edit text" area of the chart title box in a chart in Excel 2010 and type "=B27" (without the quotation marks, and understanding the contents of "B27" has the text I wish to display) does this idiot thing simply display "=B27" (again, without the quotation marks)???
View 4 Replies View RelatedI am trying to make the contents of a cell into a chart title.I know I can do it like this...
ActiveChart.ChartTitle.Select
Selection.Caption = "=tab_name!R2C1"
However, I am trying to use the same macro on several different tabs in the same EXCEL worksheet. Obviously, I can't have the tab name in the macro. But, I don't get a title at all when I try to remove it like this...
ActiveChart.ChartTitle.Select
Selection.Caption = "=R2C1"
or
ActiveChart.ChartTitle.Select
Selection.Caption = "=A2"
Is this possible? I am (kinda new at) using EXCEL2010.
Code to go to a certain slide in Powerpoint. I kept trying to run the code in Excel VBA and it never worked.
So I said "why not try this code in Powerpoint to see if it works?' and, low and behold, it worked!
What I need is to get the code below, which works in Powerpoint VBA, to work in Excel VBA.
Code:
Sub gothere()
On Error Resume Next
ActivePresentation.SlideShowWindow.View.GotoSlide 3
If Err 0 Then ActiveWindow.View.GotoSlide 3
End Sub
I have a table in excel where I'm trying to hyperlink to specific side in a powerpoint presentation. I've found various sites instructing me to use #slidenumber (eg #4) at the end of the filename when editing the link, however many different combinations of slide numbers and names i use it refuses to open the deck at that set slide, always taking me to the beginning. I've tried using the bookmark option in excel but that gives a error messaging stating bookmarks cannot be used in xml files.
View 1 Replies View RelatedAfter we all spend lots of time developing a macro, we have the desire to show others who may not understand or appreciate what is going on during the time the macro is running.
What is the best way for Excel to explain/display what it is doing in "Laymens Terms" WHILE it's running? (if possible).
I was thinking of something like a slide? It would be good if the text can change at points decided by the person who put the macro together.
I am using an excel spread sheet as a larger display on a huge projected screen with numbers at a large charity event. It is a reverse raffle, so as your name is called you are out of the raffle. I would like to link the cell to a specific powerpoint slide which has the name and town of the specific ticket buyer. When double clicking on the cell listing their number the ticket buyers name and town would appear as a powerpoint a window in the middlle of the excel screen for all to see and then disappear after a few seconds or disappear when the next cell is double clicked. putting excel data into powerpoint slldes but not the other way around!
View 7 Replies View RelatedI am trying to write a macro that goes in an excel file that creates a powerpoint presentation, and puts four (4) charts in each slide.. I currently have a code that is pasting all of the charts in the same slide and I can't figure out why it isn't working (side note: I haven't attempted to resize or relocate the pictures on the powerpoint slides yet)..
Code:
'Add a reference to the Microsoft PowerPoint Library by:
'1. Go to Tools in the VBA menu
'2. Click on Reference
'3. Scroll down to Microsoft PowerPoint X.0 Object Library, check the box, and press Okay
'keep button in same location
Set btn = ActiveSheet.Shapes("CommandButton17")
With btn
btLeft = .Left
btTop = .Top
End With
[code]....
How do I paste the first chart into the second chart but maintain the format of the second chart?
View 2 Replies View RelatedThe title bar is missing for one 2002 file. This is the same bar that has the minimize/maximize button in the right corner.
My mind is drawing a blank for a fix. I've tried the *view, tool bar, customize* and can't find the missing bar.
I have a column of numbers at random intervals which I am trying to insert totals into, the totals should only total the cells since the last total. Take a look at the code I started that I thought might do the trick and revel in the amateurishness of it all!
Sub TB
Range("A2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
ActiveCell.FormulaR1C1 = "=SUM(R[-5]C:R[-1]C)"
End Sub .......
I have 2 spreadsheets. First one has monthly results and columns are named with abbreviations. Second sheets is for presentation, has only a select number of lines and full names instead of abbreviations. This second sheet is supposed to pull values from sheet 1 but I don't know how to call up those values since the titles are different. Short of using SUM I don't know what to do.
View 7 Replies View RelatedExcel 2003. How can I put an icon in the title bar of an Excel Workbook? And can it be a .jpg or does it need to be a .icon. How can I put a title and NOT see " Microsoft Excel" in the title bar.
View 3 Replies View Related