Hi!
I've been searching but had no luck to find if there is any possible way to make a chart like this automatic in Excel, do you think it is possible? If yes... how so?
Hope you can help, thanks in advance!
The short answer is no. But it can be done with automation. You would need a range somewhere (does not have to be the same worksheet) for the data input. Then you would need a vba (or other code) procedure to tell Excel how to fill in the cells based on the data range. The Row height and column width could be preset or you coul also do that in the code. But why would you want to do that when you can just fill in a data range and use the chart wizard to create a chart that you can customize?
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.
