Hi
I never used VBA for Excel before.
Why this command give error, second one also, but If I uncomment "On Error..." second one fill chart as should be.
Sorry for picture, not source. I used this at work, now I'm at home...
Any advice?
Many thanks,
BaGRoS
Hi all,
Hope you are doing well.
I'm coming on this forum because i really need your help and i'm a big beginner with VBA.
I have 3 charts :
-Chart1
-Chart2
-Chart3
I want to update multiple series ranges on these charts with a one VBA code like below :
Chart 1
-Update "Serie 1" with the...
Hi
I've written a macro which updates a clustered column chart in Sheet 1 that's based on data in a table in Sheet 2. However, the chart is not fully updating.
The ‘source data’ for the chart is =Table5[#All]
(based on a table that currently exists in Sheet2).
The table in Sheet 2 is...
Hi All,
I have a question regarding charts, and was hoping someone might be able to help.
If you have an embedded chart with a series in it, is it possible, using vba, to obtain the x or y values/range referenced, and then write that to a cell.
e.g. if the x-values for series Case 2 is...
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.