Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy with format | New Users to Excel | |||
Problem with BUBBLE CHART scale and legend | Charts and Charting in Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
e-mailing or exporting charts as a .pdf or .tif format | Charts and Charting in Excel |