Stack Column and Shapes in Excel

MeetGlen

New Member
Joined
Aug 8, 2011
Messages
21
Hi All,

I am not able to work on the Stack Column Chart in VBA. One main reason i understood from the debug was its not able to reference to particular chart when it becomes active. Help on this would be very much appreciated.

And second aspect is if there is any workaround in working out excel shapes in excel.

Hope i making it understandable.

Thank you for the help.

Regards Glen
 
The position you given works fine. The reason i asked was the positioning takes place for the plot area, but when the series/chart area is visible its not the same as intended. i will work on it, thanks Glenn for it.

And the fonts works as intended. Please also let me know how to fill the series area.

Thank you.
 
Upvote 0

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
How about:

ActiveChart.SeriesCollection(1).Interior.ColorIndex = 6
?
 
Upvote 0
Hi Glenn,

Thanks for the continous support.

color 6 seems to work fine.

But is there a possibility for

Red
ActiveChart.SeriesCollection(1).Interior.ColorIndex = RGB(255, 0, 0)
Green
ActiveChart.SeriesCollection(2).Interior.ColorIndex = RGB(0,176,80)

Thank you.
 
Upvote 0
Thank you so much Glenn. The coloring works well without the index

Please also request you for the code remove the line in the chart area which comes under Border Color.
 
Upvote 0
Please could you help in deleting an entire row if it does not have the same number value format in a cell.

My Scenario. I have columns A2:I2 and my criteria starts from C3 untill xldown having numbers like 40006330, 40006340, 40006350 etc..

Hence i want to identify the values in C3:C having like the above 8digits, then once indentified would like to delete the entire rows which is not having the 8digits numbers.

Please help me with this also.
 
Upvote 0
Hi Glenn,

i just got the code, by trying the combinations, for removing the lines in the stack chart:

ActiveChart.PlotArea.Format.Line.Visible = msoFalse

ActiveChart.ChartArea.Format.Line.Visible = msoFalse

'But still trying for the deleting the entire row based on the said condition:confused:
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,972
Members
448,537
Latest member
Et_Cetera

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