Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 19th 09, 04:16 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 46
Default Chart to display zeroes values

Hello,

I have a strange question. I have a clustered column chart where some values
are zero. In such cases, no column appears for these observations (i.e. a
column of zero height). Anyway to make the column appears for these zero
values? There are 8 categories (a thru h) and I want to display 8 bars
representing each category even if the value is zero. Then, I would like to
have the data label displays inside each of the bar representing the value.
Can this be done?

with the following group of data
F08 F09 F10 F11 F12
a 2 0 0 0 0
b 0 0 0 3 1
c 1 1 0 0 0
d 1 2 0 1 1
e 2 0 0 1 0
f 0 0 0 0 3
g 1 0 1 0 0
h 1 0 0 1 0



  #2   Report Post  
Old May 19th 09, 02:30 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 120
Default Chart to display zeroes values

Make another array of functions
= B1+1 (if B1 = 2 - your nomenclature is rather messy) and copy in the
right from your array in the same dimension (just enlarge your values by a
certain number, 0.5 or 1 is proper in your sizes).
Make bar chart from these new values as you got accustomed to.
Add a number (proper value 4, does not matter) in the next near column,
and add another, dummy series based on this single value.
Link two original series to the secondary axis.
Set limits of the primary axis to -1 to 4, of the secondary one to 0 to 5.
All zero bars appear in the height of -1 to 0 (by primary a.).
Set the format of the third, auxiliary series to: Boundaries None, Area None.
The third series bar thereby disappears.
Select the secondary axis and set Font Color Blank, Background Transparent.
The secondary axis legend disappears.
Play around with the widths and spaces of bars.
With labels follow the help.
Regards

--
Petr Bezucha


"Bagia" wrote:

Hello,

I have a strange question. I have a clustered column chart where some values
are zero. In such cases, no column appears for these observations (i.e. a
column of zero height). Anyway to make the column appears for these zero
values? There are 8 categories (a thru h) and I want to display 8 bars
representing each category even if the value is zero. Then, I would like to
have the data label displays inside each of the bar representing the value.
Can this be done?

with the following group of data
F08 F09 F10 F11 F12
a 2 0 0 0 0
b 0 0 0 3 1
c 1 1 0 0 0
d 1 2 0 1 1
e 2 0 0 1 0
f 0 0 0 0 3
g 1 0 1 0 0
h 1 0 0 1 0


  #3   Report Post  
Old May 19th 09, 08:04 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 46
Default Chart to display zeroes values

Is there an easier way, because your steps are too complex for me.

"PBezucha" wrote:

Make another array of functions
= B1+1 (if B1 = 2 - your nomenclature is rather messy) and copy in the
right from your array in the same dimension (just enlarge your values by a
certain number, 0.5 or 1 is proper in your sizes).
Make bar chart from these new values as you got accustomed to.
Add a number (proper value 4, does not matter) in the next near column,
and add another, dummy series based on this single value.
Link two original series to the secondary axis.
Set limits of the primary axis to -1 to 4, of the secondary one to 0 to 5.
All zero bars appear in the height of -1 to 0 (by primary a.).
Set the format of the third, auxiliary series to: Boundaries None, Area None.
The third series bar thereby disappears.
Select the secondary axis and set Font Color Blank, Background Transparent.
The secondary axis legend disappears.
Play around with the widths and spaces of bars.
With labels follow the help.
Regards

--
Petr Bezucha


"Bagia" wrote:

Hello,

I have a strange question. I have a clustered column chart where some values
are zero. In such cases, no column appears for these observations (i.e. a
column of zero height). Anyway to make the column appears for these zero
values? There are 8 categories (a thru h) and I want to display 8 bars
representing each category even if the value is zero. Then, I would like to
have the data label displays inside each of the bar representing the value.
Can this be done?

with the following group of data
F08 F09 F10 F11 F12
a 2 0 0 0 0
b 0 0 0 3 1
c 1 1 0 0 0
d 1 2 0 1 1
e 2 0 0 1 0
f 0 0 0 0 3
g 1 0 1 0 0
h 1 0 0 1 0




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Omitting zeroes when looking for minimum values pdeaston Excel Worksheet Functions 2 June 24th 07 01:43 AM
how do i remove zeroes values from exel sheet Ana New Users to Excel 10 June 14th 07 06:24 PM
Want chart to display total of values chipconnection Charts and Charting in Excel 0 December 31st 06 09:50 PM
Display Error Bar values on chart? [email protected] Charts and Charting in Excel 1 November 18th 06 05:19 AM
Don't won't charts to display Zeroes metro Charts and Charting in Excel 2 February 28th 05 12:35 AM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017