software

I have Line charts on various sheets. The charts are identical in size.
There are 12 items graphed on each chart. However, the legend on each of
the charts seems to be displaying different numbers of charted items. I'm
not sure how to explain this clearly.

On one chart's legend, it might show 12 items (three columns with four items
each), which is correct. Another chart's legend may only show 2 columns
totally only eight items (it should be 12). I even have one chart's legend
showing only 4 items (as if it is only one column displaying).

I can't figure out what could be different from one legend to the next.

Any ideas?

Thanks,
Paul
It might be that different legend entry string lengths cause a column of
legend entries to disappear. Can you select the legend and resize it using
the handles? Does that bring back the missing entries?

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

quot;PCLIVEquot; gt; wrote in message
...
gt;I have Line charts on various sheets. The charts are identical in size.
gt;There are 12 items graphed on each chart. However, the legend on each of
gt;the charts seems to be displaying different numbers of charted items. I'm
gt;not sure how to explain this clearly.
gt;
gt; On one chart's legend, it might show 12 items (three columns with four
gt; items each), which is correct. Another chart's legend may only show 2
gt; columns totally only eight items (it should be 12). I even have one
gt; chart's legend showing only 4 items (as if it is only one column
gt; displaying).
gt;
gt; I can't figure out what could be different from one legend to the next.
gt;
gt; Any ideas?
gt;
gt; Thanks,
gt; Paul
gt;
If I resize it tall-wise, it displays more. But I'm trying to figure out
how the other legends are being displayed in three columns. That's what I
want. When you click to resize, you can see gridlines that indicate where
the columns/rows are for each item. When I make resize this legend (that is
only displaying 4 items) larger, it just shows everything in what appears to
be one column. The other's clearly display 3 columns when clicking to
resize the legend.

Any ideas?

Thanks again,
Paul

quot;Jon Peltierquot; gt; wrote in message
...
gt; It might be that different legend entry string lengths cause a column of
gt; legend entries to disappear. Can you select the legend and resize it using
gt; the handles? Does that bring back the missing entries?
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;PCLIVEquot; gt; wrote in message
gt; ...
gt;gt;I have Line charts on various sheets. The charts are identical in size.
gt;gt;There are 12 items graphed on each chart. However, the legend on each of
gt;gt;the charts seems to be displaying different numbers of charted items. I'm
gt;gt;not sure how to explain this clearly.
gt;gt;
gt;gt; On one chart's legend, it might show 12 items (three columns with four
gt;gt; items each), which is correct. Another chart's legend may only show 2
gt;gt; columns totally only eight items (it should be 12). I even have one
gt;gt; chart's legend showing only 4 items (as if it is only one column
gt;gt; displaying).
gt;gt;
gt;gt; I can't figure out what could be different from one legend to the next.
gt;gt;
gt;gt; Any ideas?
gt;gt;
gt;gt; Thanks,
gt;gt; Paul
gt;gt;
gt;
gt;
To make the legend show three columns instead of two, you have to make the
legend wide enough to fit three columns. So either stretch the legend
width-wise, or shorten the series names.

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

quot;PCLIVEquot; gt; wrote in message
...
gt; If I resize it tall-wise, it displays more. But I'm trying to figure out
gt; how the other legends are being displayed in three columns. That's what I
gt; want. When you click to resize, you can see gridlines that indicate where
gt; the columns/rows are for each item. When I make resize this legend (that
gt; is only displaying 4 items) larger, it just shows everything in what
gt; appears to be one column. The other's clearly display 3 columns when
gt; clicking to resize the legend.
gt;
gt; Any ideas?
gt;
gt; Thanks again,
gt; Paul
gt;
gt; quot;Jon Peltierquot; gt; wrote in message
gt; ...
gt;gt; It might be that different legend entry string lengths cause a column of
gt;gt; legend entries to disappear. Can you select the legend and resize it
gt;gt; using the handles? Does that bring back the missing entries?
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt; quot;PCLIVEquot; gt; wrote in message
gt;gt; ...
gt;gt;gt;I have Line charts on various sheets. The charts are identical in size.
gt;gt;gt;There are 12 items graphed on each chart. However, the legend on each of
gt;gt;gt;the charts seems to be displaying different numbers of charted items.
gt;gt;gt;I'm not sure how to explain this clearly.
gt;gt;gt;
gt;gt;gt; On one chart's legend, it might show 12 items (three columns with four
gt;gt;gt; items each), which is correct. Another chart's legend may only show 2
gt;gt;gt; columns totally only eight items (it should be 12). I even have one
gt;gt;gt; chart's legend showing only 4 items (as if it is only one column
gt;gt;gt; displaying).
gt;gt;gt;
gt;gt;gt; I can't figure out what could be different from one legend to the next.
gt;gt;gt;
gt;gt;gt; Any ideas?
gt;gt;gt;
gt;gt;gt; Thanks,
gt;gt;gt; Paul
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Thanks Jon,

Apparently, one of the items was really long and the legend is set to make
all columns equal. Well I had to stretch it pretty far before it would add
columns. I wish there was a way to have it wrap, or just not display the
remaining text so that three columns would be visible without resizing. It
would also be nice if I could specify each column width or the width would
be automatically determined by the longest text length in that column.

Anyway, you helped me and I'll just have to work with it from here.

Thanks,
Paul

quot;Jon Peltierquot; gt; wrote in message
...
gt; To make the legend show three columns instead of two, you have to make the
gt; legend wide enough to fit three columns. So either stretch the legend
gt; width-wise, or shorten the series names.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;PCLIVEquot; gt; wrote in message
gt; ...
gt;gt; If I resize it tall-wise, it displays more. But I'm trying to figure out
gt;gt; how the other legends are being displayed in three columns. That's what
gt;gt; I want. When you click to resize, you can see gridlines that indicate
gt;gt; where the columns/rows are for each item. When I make resize this legend
gt;gt; (that is only displaying 4 items) larger, it just shows everything in
gt;gt; what appears to be one column. The other's clearly display 3 columns
gt;gt; when clicking to resize the legend.
gt;gt;
gt;gt; Any ideas?
gt;gt;
gt;gt; Thanks again,
gt;gt; Paul
gt;gt;
gt;gt; quot;Jon Peltierquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; It might be that different legend entry string lengths cause a column of
gt;gt;gt; legend entries to disappear. Can you select the legend and resize it
gt;gt;gt; using the handles? Does that bring back the missing entries?
gt;gt;gt;
gt;gt;gt; - Jon
gt;gt;gt; -------
gt;gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt;gt; Peltier Technical Services
gt;gt;gt; Tutorials and Custom Solutions
gt;gt;gt; PeltierTech.com/
gt;gt;gt; _______
gt;gt;gt;
gt;gt;gt; quot;PCLIVEquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt;I have Line charts on various sheets. The charts are identical in size.
gt;gt;gt;gt;There are 12 items graphed on each chart. However, the legend on each
gt;gt;gt;gt;of the charts seems to be displaying different numbers of charted items.
gt;gt;gt;gt;I'm not sure how to explain this clearly.
gt;gt;gt;gt;
gt;gt;gt;gt; On one chart's legend, it might show 12 items (three columns with four
gt;gt;gt;gt; items each), which is correct. Another chart's legend may only show 2
gt;gt;gt;gt; columns totally only eight items (it should be 12). I even have one
gt;gt;gt;gt; chart's legend showing only 4 items (as if it is only one column
gt;gt;gt;gt; displaying).
gt;gt;gt;gt;
gt;gt;gt;gt; I can't figure out what could be different from one legend to the next.
gt;gt;gt;gt;
gt;gt;gt;gt; Any ideas?
gt;gt;gt;gt;
gt;gt;gt;gt; Thanks,
gt;gt;gt;gt; Paul
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Paul, there is a way to force a line break in your legend label. Assuming
your label name is in a worksheet cell, say quot;Sales 2000quot; and you want the
break behind Sales so 2000 appears below Sales. Use
=CONCATENATE(quot;Salesquot;,CHAR(13),quot;2000quot;) - the CHAR(13) forces the line break.
(in the worksheet cell you shd see an empty little square between Sales and
2000). This trick also comes handy to control x-axis labels (e.g. May 2006,
where u want 2006 below May because otherwise the label becomes too large).
Hope this works for you.

Regards,
Henk

quot;PCLIVEquot; wrote:

gt; Thanks Jon,
gt;
gt; Apparently, one of the items was really long and the legend is set to make
gt; all columns equal. Well I had to stretch it pretty far before it would add
gt; columns. I wish there was a way to have it wrap, or just not display the
gt; remaining text so that three columns would be visible without resizing. It
gt; would also be nice if I could specify each column width or the width would
gt; be automatically determined by the longest text length in that column.
gt;
gt; Anyway, you helped me and I'll just have to work with it from here.
gt;
gt; Thanks,
gt; Paul
gt;
gt; quot;Jon Peltierquot; gt; wrote in message
gt; ...
gt; gt; To make the legend show three columns instead of two, you have to make the
gt; gt; legend wide enough to fit three columns. So either stretch the legend
gt; gt; width-wise, or shorten the series names.
gt; gt;
gt; gt; - Jon
gt; gt; -------
gt; gt; Jon Peltier, Microsoft Excel MVP
gt; gt; Peltier Technical Services
gt; gt; Tutorials and Custom Solutions
gt; gt; PeltierTech.com/
gt; gt; _______
gt; gt;
gt; gt; quot;PCLIVEquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; If I resize it tall-wise, it displays more. But I'm trying to figure out
gt; gt;gt; how the other legends are being displayed in three columns. That's what
gt; gt;gt; I want. When you click to resize, you can see gridlines that indicate
gt; gt;gt; where the columns/rows are for each item. When I make resize this legend
gt; gt;gt; (that is only displaying 4 items) larger, it just shows everything in
gt; gt;gt; what appears to be one column. The other's clearly display 3 columns
gt; gt;gt; when clicking to resize the legend.
gt; gt;gt;
gt; gt;gt; Any ideas?
gt; gt;gt;
gt; gt;gt; Thanks again,
gt; gt;gt; Paul
gt; gt;gt;
gt; gt;gt; quot;Jon Peltierquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt;gt; It might be that different legend entry string lengths cause a column of
gt; gt;gt;gt; legend entries to disappear. Can you select the legend and resize it
gt; gt;gt;gt; using the handles? Does that bring back the missing entries?
gt; gt;gt;gt;
gt; gt;gt;gt; - Jon
gt; gt;gt;gt; -------
gt; gt;gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt;gt;gt; Peltier Technical Services
gt; gt;gt;gt; Tutorials and Custom Solutions
gt; gt;gt;gt; PeltierTech.com/
gt; gt;gt;gt; _______
gt; gt;gt;gt;
gt; gt;gt;gt; quot;PCLIVEquot; gt; wrote in message
gt; gt;gt;gt; ...
gt; gt;gt;gt;gt;I have Line charts on various sheets. The charts are identical in size.
gt; gt;gt;gt;gt;There are 12 items graphed on each chart. However, the legend on each
gt; gt;gt;gt;gt;of the charts seems to be displaying different numbers of charted items.
gt; gt;gt;gt;gt;I'm not sure how to explain this clearly.
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt; On one chart's legend, it might show 12 items (three columns with four
gt; gt;gt;gt;gt; items each), which is correct. Another chart's legend may only show 2
gt; gt;gt;gt;gt; columns totally only eight items (it should be 12). I even have one
gt; gt;gt;gt;gt; chart's legend showing only 4 items (as if it is only one column
gt; gt;gt;gt;gt; displaying).
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt; I can't figure out what could be different from one legend to the next.
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt; Any ideas?
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt; Thanks,
gt; gt;gt;gt;gt; Paul
gt; gt;gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

It's easier than that. Put your cursor in the cell where you want a new
line, and press Alt Enter.

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

quot;HEKquot; gt; wrote in message
...
gt; Paul, there is a way to force a line break in your legend label. Assuming
gt; your label name is in a worksheet cell, say quot;Sales 2000quot; and you want the
gt; break behind Sales so 2000 appears below Sales. Use
gt; =CONCATENATE(quot;Salesquot;,CHAR(13),quot;2000quot;) - the CHAR(13) forces the line
gt; break.
gt; (in the worksheet cell you shd see an empty little square between Sales
gt; and
gt; 2000). This trick also comes handy to control x-axis labels (e.g. May
gt; 2006,
gt; where u want 2006 below May because otherwise the label becomes too
gt; large).
gt; Hope this works for you.
gt;
gt; Regards,
gt; Henk
gt;
gt; quot;PCLIVEquot; wrote:
gt;
gt;gt; Thanks Jon,
gt;gt;
gt;gt; Apparently, one of the items was really long and the legend is set to
gt;gt; make
gt;gt; all columns equal. Well I had to stretch it pretty far before it would
gt;gt; add
gt;gt; columns. I wish there was a way to have it wrap, or just not display the
gt;gt; remaining text so that three columns would be visible without resizing.
gt;gt; It
gt;gt; would also be nice if I could specify each column width or the width
gt;gt; would
gt;gt; be automatically determined by the longest text length in that column.
gt;gt;
gt;gt; Anyway, you helped me and I'll just have to work with it from here.
gt;gt;
gt;gt; Thanks,
gt;gt; Paul
gt;gt;
gt;gt; quot;Jon Peltierquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; To make the legend show three columns instead of two, you have to make
gt;gt; gt; the
gt;gt; gt; legend wide enough to fit three columns. So either stretch the legend
gt;gt; gt; width-wise, or shorten the series names.
gt;gt; gt;
gt;gt; gt; - Jon
gt;gt; gt; -------
gt;gt; gt; Jon Peltier, Microsoft Excel MVP
gt;gt; gt; Peltier Technical Services
gt;gt; gt; Tutorials and Custom Solutions
gt;gt; gt; PeltierTech.com/
gt;gt; gt; _______
gt;gt; gt;
gt;gt; gt; quot;PCLIVEquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; If I resize it tall-wise, it displays more. But I'm trying to figure
gt;gt; gt;gt; out
gt;gt; gt;gt; how the other legends are being displayed in three columns. That's
gt;gt; gt;gt; what
gt;gt; gt;gt; I want. When you click to resize, you can see gridlines that indicate
gt;gt; gt;gt; where the columns/rows are for each item. When I make resize this
gt;gt; gt;gt; legend
gt;gt; gt;gt; (that is only displaying 4 items) larger, it just shows everything in
gt;gt; gt;gt; what appears to be one column. The other's clearly display 3 columns
gt;gt; gt;gt; when clicking to resize the legend.
gt;gt; gt;gt;
gt;gt; gt;gt; Any ideas?
gt;gt; gt;gt;
gt;gt; gt;gt; Thanks again,
gt;gt; gt;gt; Paul
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Jon Peltierquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt;gt; It might be that different legend entry string lengths cause a column
gt;gt; gt;gt;gt; of
gt;gt; gt;gt;gt; legend entries to disappear. Can you select the legend and resize it
gt;gt; gt;gt;gt; using the handles? Does that bring back the missing entries?
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt; - Jon
gt;gt; gt;gt;gt; -------
gt;gt; gt;gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; gt;gt;gt; Peltier Technical Services
gt;gt; gt;gt;gt; Tutorials and Custom Solutions
gt;gt; gt;gt;gt; PeltierTech.com/
gt;gt; gt;gt;gt; _______
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt; quot;PCLIVEquot; gt; wrote in message
gt;gt; gt;gt;gt; ...
gt;gt; gt;gt;gt;gt;I have Line charts on various sheets. The charts are identical in
gt;gt; gt;gt;gt;gt;size.
gt;gt; gt;gt;gt;gt;There are 12 items graphed on each chart. However, the legend on
gt;gt; gt;gt;gt;gt;each
gt;gt; gt;gt;gt;gt;of the charts seems to be displaying different numbers of charted
gt;gt; gt;gt;gt;gt;items.
gt;gt; gt;gt;gt;gt;I'm not sure how to explain this clearly.
gt;gt; gt;gt;gt;gt;
gt;gt; gt;gt;gt;gt; On one chart's legend, it might show 12 items (three columns with
gt;gt; gt;gt;gt;gt; four
gt;gt; gt;gt;gt;gt; items each), which is correct. Another chart's legend may only show
gt;gt; gt;gt;gt;gt; 2
gt;gt; gt;gt;gt;gt; columns totally only eight items (it should be 12). I even have one
gt;gt; gt;gt;gt;gt; chart's legend showing only 4 items (as if it is only one column
gt;gt; gt;gt;gt;gt; displaying).
gt;gt; gt;gt;gt;gt;
gt;gt; gt;gt;gt;gt; I can't figure out what could be different from one legend to the
gt;gt; gt;gt;gt;gt; next.
gt;gt; gt;gt;gt;gt;
gt;gt; gt;gt;gt;gt; Any ideas?
gt;gt; gt;gt;gt;gt;
gt;gt; gt;gt;gt;gt; Thanks,
gt;gt; gt;gt;gt;gt; Paul
gt;gt; gt;gt;gt;gt;
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;