Hi Experts,
Can some one help me on what is chi-Square table and Chart? how to create them? what is the use of these charts and tables?
Thanks,
Balajisx
I have created two set of data in excel which shows the actual vs target, and created a line chart and added it to the power point. I am looking for a macro when ever the actual value reaches or exceeds the target value in the chart the sounds should be played automatically using powerpoint vba...
I have also tried with offset function and this too works fine. I hope this will help others who have similar question.
here is the formula
=SUM(OFFSET($C$1,1,0,MONTH(TODAY()),1))
regards,
Balajisx
Hi Team,
I have budget and Invoice amount month on month. I want to create a dynamic formula in C15 if I add any values for May month invoice it should sum only till may in budget. Like wise if I add any data for June month invoice the budget MTD should sum till June. Please help me on this...
The requirement is to keep the charts and groups in the same format what I have in excel. when I tried using ppapp.CommandBars.ExecuteMso ("PasteSourceFormatting") command, I am getting this run time error. If I change the pasting type as Bitmap or JPEG when ever I run the code the picture name...
Cross Posting :
I have asked the same question in the another forum
link below
https://www.excelforum.com/excel-programming-vba-macros/1192577-cross-post-how-to-fix-the-error-method-itemof-the-object-shapesfailed.html#post4695699
Hi All,
I am working on automation where I am exporting the charts from excel to powerpoint.
When I run the code by step by step it is working perfectly. However when I run the sub command I am getting the runtime error stating 'Method 'item'of the object 'shapes'failed'. I tried with couple of...
Wow.. Looks cool. Thank you so much SirJB7. let me try to understand the code and will find the powerpoint objects and references.
once again thank you so much!!
regards,
Balajisx
Hi Team,
cross posting link below
https://www.excelforum.com/excel-programming-vba-macros/1192294-how-to-name-a-object-or-picture-in-powerpoiint-using-vba.html#post4693961
I am working on a excel to power point automation. I have couple of charts and headers and few shapes. Based on my...
Hi Team,
I have asked the same question in a different forum. link below
https://www.excelforum.com/excel-general/1190900-if-condition-for-a-range.html#post4689244
1. I have a raw data which contains the quality details like agent name, files audited ,pass or fail . I have converted this data...
Hi Chihiro,
I am not aware that We should not do a cross posting. I apologize for that. Going forward I will make sure to add the answer if I get it from some other forum.
Regards,
Balajisx
Hi Team,
I have a worksheet with mutliple charts and excel widgets. I have to paste each grouped chart into a powerpoint silde. I will be able to copy each chart or each shape individually to powerpoint using VBA. However I m struggling to copy and paste the grouped charts and shapes into...
Hi Team,
please help me in finding the formula.
I have uploaded a sample file which contains the Quality score of the employees. I want to find out the below
QIP 1 - if the agent quality score fall below 95 % for consecutive 2 weeks then he will be in QIP 1
QIP 2 - if the agent quality score...
I am not able to attach the powerpoint template in this forum. Hence I have taken a snap shot of my slides and pasted in the attached excel file. My working excel will contains some basic column and bar charts like what we see in the link which you shared Earlier. by using the code am able to...
Hi Narayan, Here is the sample file for your review. I have added the data to data model and calculated the quality score for researcher. Now I want to see the QIP status. Please help me on this.
All my working files and charts will be excel . I have to automate the presentation via excel only. Instead of creating a new presentation I have to use format of tempalte. is that possible via Excel VBA?
Hi All,
I am working on quality dashboard where I have to add a column for QIP stage.
I have to add a column to find whether it is in QIP 1 OR 2 OR Call for action.
The definitation is given below.
1.Quality Improvement Phase 1 (QIP1)
scheduled when QA quality scores fall below 95% for 2...
Thank you so much Narayan. This is what I am actually looking for. However Instead of creating a new powerpoint presentation, is there any way to create an automation for active powerpoint presentation? Say for an example, I have a standard master slide "A standard template" which needs to be...