VBA to create and format graph

VEVE4014

New Member
Joined
May 15, 2024
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hello, im struggling with programing in VBA,
my goal is to make a program who create a graph using a table made by the user in a Excel spreadsheet (this part of my program is working)
then i want the program to copy paste the format of an hand-made graph on the spreadsheet to the new created graph.
i assume the problem in my code is when i try to select the graphique, or when i try to copy or paste the format on the other graph.

The final goal would be to make the user able to create and format a graph just clicking on 1 button then selecting the table and the graph.
i already tryed to ask AI for help but i can't find any code that work.

Thanks for anyone answering and sorry or my not perfect english
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,224,818
Messages
6,181,151
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top