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

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,218,499
Messages
6,142,831
Members
450,449
Latest member
Dave Carr QM

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