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.