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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

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,144,056
Messages
5,722,261
Members
422,419
Latest member
Havok390

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