Good afternoon everyone!
I need to export multiple charts from multiple sheets to just one PDF file, but until now I couldn't do that. I only can export PDFs separetedely. Does anyone has a code to do that?? I've searched a lot in google and forums, but I wasn't able to find anything that could...
Hello,
Looking for some help / advice please.
I have the below table of data - which i have created into a stacked bar chart to show each band and the equivalent band widths (minimum-maximum). The chart then has a line chart over it to show the average at each band.
<tbody>
Band
Average...
Hi,
As the title states, I'm trying to add the same range of data labels (initials) to 9 out of a total of 13 charts on one sheet. I'm using this popular macro to add labels successfully to 1 chart (Chart 1):
Sub AddDataLabels()' Disable screen updating while the subroutine is run...
Would greatly appreciate any help!
I have 4 tables each containing thirty rows. I am using the first row of each table to build the first chart. I need move down to the second row of each table to build the second chart. I need to do this for all the thirty rows and to change the chart number...
Goal: Dynamically update the date range and title of multiple charts (around 20, each with between 2 and 5 series) based on a drop-down selection.
Problems:
My named range ("MonthReportRange") works when input into a chart's data range, but instead of remaining dynamic, it instantly converts...
Hello there!
I'm new to the VBA-scene and I'm learning this for work. Learned a lot the last few weeks but now my boss is asking me something I can't figure out. (Using MS Office 2010)
I did +300 Charts manually last week(s) and would like (love!) to put it in some macro's. The braindead...
Hi all,
I would like to generate a macro which can work on by importing an excel tabulated datas and plot it into several graphs in one click and added with a filter function would be best.
Here i link one of the sample of macro for this ...
Hello,
I would like to put several charts in one sheet using VBA.
Using Charts.Add makes me a new Chart sheet each time, I would like to have only one.
One more question, is there a way to resize the charts with VBA ?
Thank you in advance
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.