Thanks Guido Geurs
But this is not relevant to my problem. I want to specify that the data to be inserted in chart is not particular and I am not using linked charts here. I want an alternate to that. I need some code so that I can reach out to a particular slide and find an already existing chart and then update its data by changing it with my new data.
Regards,
Anubhav
Anubhav Mital
Last Activity: Aug 12 '11, 07:06 AM
Joined: Jun 9 '10
Location: Haryana, India
-
Anubhav Mital started a topic Automation to directly update charts of Powerpoint Presentation from Excel using VBAin Visual BasicAutomation to directly update charts of Powerpoint Presentation from Excel using VBA
Friends!!!
I am working on a project and in which I have to update the Charts in PPT again and again. I have one workbook in which my data is stored at a fixed gap, I know how to select it. And I also know how to activate the presentation but in that i don't know how to select the chart item and update its data. Help me out please.
Regards -
KK thanx buddy ....i also found the similar solution to it but i hadnt implemented it yet.. i hope it will work thanx for ur help...i case of any queries i will disturb u again..:)Leave a comment:
-
SELECT customer_name, COUNT(city) as "Distinct Cities"
FROM customers
GROUP BY customer_name;
i tried using this query and it worked but it is giving me the unique values only i.e. it is not repeating them as i want them..... and also in case i SELECT all the other fields it again gives error...
also as u said if i wont use GROUP BY then it will just give me a total number(of STUDENT/CUSTOMER...Leave a comment:
-
hey thanx for reply but that is not enough i want all the other columns in my output too and also this count
eg
student id
A
B
C
A
B
A
then i m expecting output to be
Student id count
A 3
B 2
C 1
A 3
B ...Leave a comment:
-
Sql count query
Hi all
I need help in dis, i m working on a project and here i have to design a query and it has some values(say Student ID) in columns which is repeating. So i want all the columns in output and also the number of times that Student ID is same in every record corrosponding to that student ID.......plz help itz urgent....!!! -
No issues even my english has a lot of problems....:)Leave a comment:
-
Thanx for these solutions sir,
But i just want to copy content of one excel sheet to another new excel sheet then the administrator will do the rest so tell me how i can copy content of one sheet to anotherLeave a comment:
-
Thanx for ur help
But can u make it more clear. I am new to VB. I also need some suggestion for the case that if we have to copy any excel sheet into another excel sheet of one workbook to another...Leave a comment:
-
How to show a promt for any change detected in excel sheet
i have a project in which we have a database as backend and excel as front end in it first we allow user to access the data of MS Access in excel and update it then we get it saved at some place. now administrator needs help that he wants a prompt every time for the changes that have been made in data... -
How to show a promt for any change detected in excel sheet
i have a project in which we have a database as backend and excel as front end in it first we allow user to access the data of MS Access in excel and update it then we get it saved at some place. now administrator needs help that he wants a prompt every time for the changes that have been made in data...
No activity results to display
Leave a comment: