Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel "no data" labeling in bar graph
Hello,
I am graphing a series of data in a bar format in excel. Some of the entries have no data. Instead of interpolating, graphing zero, or just leaving gaps, I'd like excel to put a "no data" or similar message in the spot where a bar would otherwise be. (I can't have it shown as zero, as there are legitimate zero entries as well.) How do I do this? I am using excel 2003. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel "no data" labeling in bar graph
I think you will need a column of data labels that could be placed on your
chart with one of these add-ins Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com best wishes -- Bernard Liengme MVP Excel http://people.stfx.ca/bliengme "David NGC" <David wrote in message ... Hello, I am graphing a series of data in a bar format in excel. Some of the entries have no data. Instead of interpolating, graphing zero, or just leaving gaps, I'd like excel to put a "no data" or similar message in the spot where a bar would otherwise be. (I can't have it shown as zero, as there are legitimate zero entries as well.) How do I do this? I am using excel 2003. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel "no data" labeling in bar graph
Thank you for the help. I will attempt one of these if it is a that option,
but i'm on a corporate network which presents me with two problems: 1) I may get in trouble for installing a third party app on this computer. 2) This worksheet will be worked on by many people after I'm gone (summer internship) and whatever is done to it should probably be done with the stock excel for compatibility reasons. If anyone else has suggestions for anything I can do without a third party app, I'd appreciate it. It doesn't have to say "no data". It could be as simple as an "X", or a line, or just shading applied where the missing data bar would go. thanks "Bernard Liengme" wrote: I think you will need a column of data labels that could be placed on your chart with one of these add-ins Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com best wishes -- Bernard Liengme MVP Excel http://people.stfx.ca/bliengme "David NGC" <David wrote in message ... Hello, I am graphing a series of data in a bar format in excel. Some of the entries have no data. Instead of interpolating, graphing zero, or just leaving gaps, I'd like excel to put a "no data" or similar message in the spot where a bar would otherwise be. (I can't have it shown as zero, as there are legitimate zero entries as well.) How do I do this? I am using excel 2003. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel "no data" labeling in bar graph
Hi,
You can use a dummy series to provide the No Data text. Assume data layout as follow, <empty is just a place holder for email post. A1:<empty B1: =Data C1: =NoData A2: =a B2: = 1 C2: =<empty A3: =b B3: = <empty C3: =0 A4: =c B4: = 0 C4: =<empty A5: =d B5: = 3 C5: =<empty Plot both series as clustered bar. Set Overlap value to 100. Series 1 displays data labels of Value Series 2 displays data labels of Series Name Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "David NGC" <David wrote in message ... Hello, I am graphing a series of data in a bar format in excel. Some of the entries have no data. Instead of interpolating, graphing zero, or just leaving gaps, I'd like excel to put a "no data" or similar message in the spot where a bar would otherwise be. (I can't have it shown as zero, as there are legitimate zero entries as well.) How do I do this? I am using excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a "fuel gauge" type graph (from 1-5) to show data | Charts and Charting in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Data Point on Graph "39409 versus 11/23/07" | Charts and Charting in Excel | |||
How do I keep graph "data table" formats in separate excel workboo | Charts and Charting in Excel | |||
Data "Point" in graph not matching table | Charts and Charting in Excel |