Pie chart - Showing Label AND Value

  • Thread starter Thread starter Rita Palazzi
  • Start date Start date
R

Rita Palazzi

Windows 2000
Office 2000

I have a pie chart with the distribution of volumes by region. The labelling
options in Excel will let me choose to show value, label, or label and %. I want
to show label and VALUE. Tried using the XYLabeler program, but it just replaces
existing labels. Does anyone know how to show label and value on a pie chart?

Thanks in advance for any help!
Rita Palazzi
Senior Engineer/FedEx Express
 
Rita -

Make a label in another range of cells that combines label and value:

=[cell address with label]&" - "&[cell address that contains value]

Now use that Chart Labeler addin.

- Jon
 
It was SOOO SIMPLE! I'm always famous for making things more difficult than they
need to be!!

Another question though:
How can I "concatenate" a line return between the region and value?


THANKS!
Rita

Jon said:
Rita -

Make a label in another range of cells that combines label and value:

=[cell address with label]&" - "&[cell address that contains value]

Now use that Chart Labeler addin.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Rita said:
Windows 2000
Office 2000

I have a pie chart with the distribution of volumes by region. The
labelling options in Excel will let me choose to show value, label, or
label and %. I want to show label and VALUE. Tried using the
XYLabeler program, but it just replaces existing labels. Does anyone
know how to show label and value on a pie chart?

Thanks in advance for any help!
Rita Palazzi
Senior Engineer/FedEx Express
Click to expand...
Click to expand...
 
Hi Rita,
use the CHAR function (code = 13):
=[cell address with label]& char(13) &[cell address that contains
value]

Frank



Rita said:
It was SOOO SIMPLE! I'm always famous for making things more
difficult than they need to be!!

Another question though:
How can I "concatenate" a line return between the region and value?


THANKS!
Rita

Jon said:
Rita -

Make a label in another range of cells that combines label and value:

=[cell address with label]&" - "&[cell address that contains value]

Now use that Chart Labeler addin.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Rita said:
Windows 2000
Office 2000

I have a pie chart with the distribution of volumes by region. The
labelling options in Excel will let me choose to show value, label,
or label and %. I want to show label and VALUE. Tried using the
XYLabeler program, but it just replaces existing labels. Does
anyone know how to show label and value on a pie chart?

Thanks in advance for any help!
Rita Palazzi
Senior Engineer/FedEx Express
Click to expand...
Click to expand...
Click to expand...
 
=FirstCell & chr(10) & SecondCell

Though, there might be some compatiblity issues with other platforms.

You might also want to try chr(10) & chr(13)

I also vaguely remember some Office program requires chr(11) instead of
chr(10)

--
Regards,

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

It was SOOO SIMPLE! I'm always famous for making things more difficult than they
need to be!!

Another question though:
How can I "concatenate" a line return between the region and value?


THANKS!
Rita

Jon said:
Rita -

Make a label in another range of cells that combines label and value:

=[cell address with label]&" - "&[cell address that contains value]

Now use that Chart Labeler addin.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Rita said:
Windows 2000
Office 2000

I have a pie chart with the distribution of volumes by region. The
labelling options in Excel will let me choose to show value, label, or
label and %. I want to show label and VALUE. Tried using the
XYLabeler program, but it just replaces existing labels. Does anyone
know how to show label and value on a pie chart?

Thanks in advance for any help!
Rita Palazzi
Senior Engineer/FedEx Express
Click to expand...
Click to expand...
Click to expand...
 
That was SOOO easy! I tend to make things more difficult than they need to be.
Have 2 more questions though:

1. How can I "concatenate" a line return between the label and value.
2. How do I keep the format of the value the same i.e. number with comma for
thousands?

Thanks!!!
Rita

Jon said:
Rita -

Make a label in another range of cells that combines label and value:

=[cell address with label]&" - "&[cell address that contains value]

Now use that Chart Labeler addin.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Rita said:
Windows 2000
Office 2000

I have a pie chart with the distribution of volumes by region. The
labelling options in Excel will let me choose to show value, label, or
label and %. I want to show label and VALUE. Tried using the
XYLabeler program, but it just replaces existing labels. Does anyone
know how to show label and value on a pie chart?

Thanks in advance for any help!
Rita Palazzi
Senior Engineer/FedEx Express
Click to expand...
Click to expand...
 
You guys are SOOO good!!! char(13) worked like a charm. I tried to cancel my
message because I had another question as well. how do I keep the format the same
i.e. number with use of comma for thousands. It's the second cell I'm referencing
in my concatenate formula.
 
Hi Rita,

I think for the first question you already got some answers. For topic
2:
You can use the formula TEXT. e.g. if you store your values in A1 and
A2
=TEXT(A1,"#,##0.00") & CHAR(13) & TEXT(A2,"#,##0.00")

Frank
 
Back
Top