Leon -
I wrote it up for my blog:
http://peltiertech.com/WordPress/hid...value-is-zero/
- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______
"Leon" wrote in message
...
On 12 Maj, 03:27, "Jon Peltier"
wrote:
Here's a trick. make the chart, apply data labels, using the values
option.
Then apply custom number formats to the data labels. For series A use
"A";;;
for series B use
"B";;;
and for series C use
"C";;;
This uses the first item ("A" etc.) for a positive number, and "" (the
space
between semicolons) for negatives and zeros.
- Jon
-------
Jon Peltier, Peltier Technical Services,
Inc.http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and
Programminghttp://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
"Leon" wrote in message
...
Hi Group
I wonder if this can be done.
Data like this
A | 0 | 3
B | 3 | 0
C | 2 | 3
1' column is legend
2' column is values to Y axis (this shoul have "1" (first stacked bar)
on the X axis)
3' column is values to Y axis (this shoul have "2" (second stacked
bar) on the X axis)
Here I would like to have 2 stacked bars
Each have legend inside bar IF value is more than 0
That would say in this case
___
___ | |
| | A |
| B |___|
|___| |
| | C |
| C | |
1 2
Hobe I explained so that you guys undetstand :-)
cheers- Skjul tekst i anførselstegn -
- Vis tekst i anførselstegn -
Hi Jon
This sounds really great. I'll try at once.
Thaks a lot!
Cheers