A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel 2007. Is it possible to format Legend Key?



 
 
Thread Tools Display Modes
  #1  
Old October 23rd, 2009, 12:11 PM posted to microsoft.public.excel.charting
jkrons
external usenet poster
 
Posts: 8
Default Excel 2007. Is it possible to format Legend Key?

Hi

I have a chart with legend displayed. I would like til increase the
size of the legend key, without increasing the legend text. Is this
possible at all?

Jan
  #2  
Old October 23rd, 2009, 12:43 PM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
 
Posts: 2,088
Default Excel 2007. Is it possible to format Legend Key?

Hi,

The legend key size is related to the legend font size.
If you have a bar/column chart then you can add a dummy series as line chart
which will cause the square legend markers to become rectangles.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"jkrons" wrote in message
...
Hi

I have a chart with legend displayed. I would like til increase the
size of the legend key, without increasing the legend text. Is this
possible at all?

Jan


  #3  
Old October 23rd, 2009, 09:30 PM posted to microsoft.public.excel.charting
Jan Kronsell
external usenet poster
 
Posts: 31
Default Excel 2007. Is it possible to format Legend Key?

Unfortuinately its a pie chart, but thanks.

Jan

Andy Pope wrote:
Hi,

The legend key size is related to the legend font size.
If you have a bar/column chart then you can add a dummy series as
line chart which will cause the square legend markers to become
rectangles.
Cheers
Andy


Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"jkrons" wrote in message
...
Hi

I have a chart with legend displayed. I would like til increase the
size of the legend key, without increasing the legend text. Is this
possible at all?

Jan



  #4  
Old October 24th, 2009, 04:15 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Excel 2007. Is it possible to format Legend Key?

That is unfortunate.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Jan Kronsell wrote:
Unfortuinately its a pie chart, but thanks.

Jan

Andy Pope wrote:
Hi,

The legend key size is related to the legend font size.
If you have a bar/column chart then you can add a dummy series as
line chart which will cause the square legend markers to become
rectangles.
Cheers
Andy


Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"jkrons" wrote in message
...
Hi

I have a chart with legend displayed. I would like til increase the
size of the legend key, without increasing the legend text. Is this
possible at all?

Jan



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.