Custom Type Charts

DeanF2000

New Member
Joined
Sep 12, 2002
Messages
3
I'm having some problems creating a Line - Column 2 Axis Charts. My target is to be able to create a chart that has multiple sets of cluster bars and multiple lines chart on a single 2 Axis chart.

Thanks ......... Dean
This message was edited by DeanF2000 on 2002-09-13 14:38
This message was edited by DeanF2000 on 2002-09-13 14:39
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Hii Dean - welcome to the board!

What eproblems are you having?? Post back with more info about what you're tryiung to do, what sort of data your using, what results you expect etc...

Paddy
 

DeanF2000

New Member
Joined
Sep 12, 2002
Messages
3
Hi Paddy,
Thanks for replying. I have created a simple spreadsheet to determine if excel will be able to comeup w/ a chart that has multiple cluster bars and multiple line2 (for 2nd Y-Axis). Unfortunately, excel chart wizard that has Line - Column 2-Axis can only 2 two cluster bars and a line. The outcome of the chart I wanted to see should have at least 10~12 cluster bars and 3~4 line (for 2nd axis) on it.
Do you happen to know if this chart for excel has already been done ??
Appreciate your help .... Dean
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
In general, if you add a data series to a chart, select the series, right click, select chart type & you can pick individual chart types for each data series. You can then format that series as you need (secondary axis etc).

Does that do it?

Paddy
 

DeanF2000

New Member
Joined
Sep 12, 2002
Messages
3
Hi Paddy, I tried editing the series but it still didn't do the job. I could only fit it 2 cluster bars and a line for the 2nd axis. It looks like a limitation on the program for that particular chart wizard.
 

Forum statistics

Threads
1,181,106
Messages
5,928,101
Members
436,588
Latest member
mummabare

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
Top