100% stacked chart in macro?!

M

mrppp

New Member
Joined
Jul 13, 2011
Messages
15
Hey,

since I have figured out how to draw a Marimekko chart, I thought it might be useful to set up a macro which facilitates and accelerates the process of creating such a chart.

Anyway, does anyone know the code for the "100% stacked chart"?
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
you might want to just record whatever you did with the macro recorder and clean it up a bit.

Code: 
Sub Macro1()
    ActiveSheet.Shapes.AddChart.Select
    ActiveChart.ChartType = xlColumnStacked100
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Gloss Colours in A Stacked Bar Chart
Replies
2
Views
115
SteveP29
S
A
  • Question Question
Creating a Pie Chart of a segment of a stacked bar in a Grouped Bar Chart (the bar chart I made is attached)
Replies
0
Views
323
afrailer
A
D
  • Question Question
Rolling chart troubleshooting
Replies
3
Views
80
Sergius
S
N
  • Question Question
Stacked Chart to show value and status YTD
Replies
2
Views
825
neilo1969
N
TheMacroNoob
  • Question Question
Stacked Clustered Column Chart
Replies
0
Views
794
TheMacroNoob
TheMacroNoob

Forum statistics

Threads
1,224,542
Messages
6,179,424
Members
452,914
Latest member
echoix

Share this page

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