anything in Excel...

It's Excel-o-lozy...

TrickPro - Total label on Stacked column chart

Putting a label of "Totals" upon respective column of "Chart with Stacked columns"...
or I should say STRUGGLING rather than PUTTING...

Not too easy but not tough too...

Simple...

Make sure "Totals" are included in the data range of chart.
Now, in the chart you can see bar of "Totals" at the top of every column.

Make sure "Data Labels" are set to Visible.
I know, question is: How to set???
Select Chart and go to menus (XL 2007) Layout > Labels > Data Labels > Centre

Now, Select top bar i.e. "Totals",
Change the type to Line from Bar,
How > Right Click on line > "Change Series Chart Type" > Line > first option

and it's done.

Little more??? Want to hide line???

ok, Right click on line > Format Data Series > Line Color > No Line...

cool??? c ya...

0 comments: