I think I may end up having to make several text boxes for my data.
Unfortunately, some of the formatting, especially objects made from the
drawing toolbar, don't copy over when I copy and paste the textbox elsewhere.
Only the letters copy over. Do you know how to copy and paste the entire
textbox, including symbols from the drawing toolbar? Many thanks...

"Tushar Mehta" wrote:

What I do -- and have done on a consistent basis -- is to put the
'legend' into textboxes, one per series. That way I can format the
legend to my hearts content (sub/superscript characters, etc). I also
set each textbox the same color as the corresponding series and add an
arrow showing what series corresponds to what textbox. In addition to
formatting each 'legend' differently, I can also position each textbox
independently of the others.

Obviously, this is something that is suited only to a 'final' version
of a chart since arrows and textboxes won't adjust themselves if the
series or the chart size change.

You could also put the information in a 'table' outside the chart --
extending the idea behind
Custom Chart Table
http://www.tushar-mehta.com/excel/ne...able/index.htm
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Thanks for the tips, however, my graph already has 8 sets of data (4 on each
y-axis) so its already quite busy. I cannot make the legend one row high
because it squishes my data too close together to see clearly(regardless if
the legend is on the right, left, or bottom, etc.), hence, I have to put it
separately as a text box I think. There may be no other way. Any
suggestions are helpful tho....

"Jon Peltier" wrote:

Unfortunately you can't tell Excel to list legend entries by column or
by row. If you stretch the legend so it's one row high, does this help
with the arrangement?

What I like to do, if the chart itself isn't too cluttered, is use data
labels to identify the points rather than a legend. The labels are right
there, so you don't force your readers to move their eyes back and forth
to identify the series in the chart. This enables you to expand the
chart into the zone previously reserved for the legend, and adds to the
simplicity of the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


beckyboucher wrote:

Yes, I have a combination line-line chart (one x-axis and two y-axes). The
entries on the first y-axis must be listed in order so they are on the same
axis, and the entries on the second y-axis must be listed together so they
are on the same axis. Unfortunately, the legend makes it look like I did
alternating entries on the different y-axes. If I put the legend on the
right side of the graph it looks OK, but I want the legend on the bottom of
the graph with two columns of data labels (with like data in the same
column), but it puts the data labels alternating, one on the right and one on
the left, instead of straight down. Any suggestions? Thanks

"Jon Peltier" wrote:


Unfortunately there are some cases in which you cannot vary the order of
the legend's entries. In a combination column-line chart, for instance,
you can rearrange the column entries amongst themselves, and likewise
the line entries. But you cannot move any of the line series above the
column series. Also, if your series are split between primary and
secondary axes, those on the primary axis will be listed before those on
the secondary axis (subject to the chart type constraint above: primary
and secondary columns are still listed before primary and secondary lines).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Tushar Mehta wrote:


An alternative to Barb's suggestion: double-click any series. In the
resulting dialog box, click the 'Series order' tab. Adjust the series
order in their using the various buttons.