ExcelBanter - Format charts legend

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Format charts legend (https://www.excelbanter.com/charts-charting-excel/113793-format-charts-legend.html)

vb_4_net

Format charts legend

Hi
I wanna format my chart like this one:
http://i10.tinypic.com/2eghct5.jpg

Kindest regards

--
vb_4_net
------------------------------------------------------------------------
vb_4_net's Profile: http://www.officehelp.in/member.php?userid=4660
View this thread: http://www.officehelp.in/showthread.php?t=1226174

Posted from - http://www.officehelp.in

Andy Pope

Format charts legend

Yes you can, sort of, you can not get the dividing line.

Add two more series to the chart with series name of Male and Female.
Change the sort order so they are at the top. Format the fill and border
of the 2 series to none.

You will need to re size the legend to get the layout of a 2 column 3
row legend.

Cheers
Andy

vb_4_net wrote:
Hi
I wanna format my chart like this one:
http://i10.tinypic.com/2eghct5.jpg

Kindest regards

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 05:53 AM.