Chart of DOOM

[slamanager]

Hi,

Not seen many chart type help questions on this forum but here goes :-

I have data over a 12 month period which has two values for team "Alpha" and two values for team "Beta" im trying to show all four values in a "Stacked / Clustered" chart.

I have been succesful in creating the chart using a secondary axis for the two returns for team beta. And I then format the font on the secondary to white, so users cannot see the scale and I then have to check the scale is the same as the primary.

The chart would show 24 stacked columns two columns for each month for the four values.

starting in B1 each cell has the month/year going to M1
A2 has Alpha A
A3 has Aplha B
A4 has Beta A
A5 has Beta B
data covers cells b2:m5

Am I using the correct method of charting the alpha data first and then copy and paste special the beta data onto teh secondary axis and setting the chart types to stacked. Is there a quick way because I have 25 charts to create and these will need to have tweeks each month as the scales change etc

 

[mole999]

have a search for john peltiers site, lots of chart help there

 

[slamanager]

will do thanks, sorry didn't google the correct terms before I posted i've also found some other ways to get my result i will post links here of what i find it seems to be a missing requirement in excel charting.