Microsoft Office Forums How to add data label individually in a stacked-bar chart?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2013, 01:26 AM
officeboy09 officeboy09 is offline How to add data label individually in a stacked-bar chart? Windows XP How to add data label individually in a stacked-bar chart? Office 2003
Advanced Beginner
How to add data label individually in a stacked-bar chart?
 
Join Date: Oct 2013
Location: Australia
Posts: 40
officeboy09 is on a distinguished road
Default How to add data label individually in a stacked-bar chart?

Hi everyone

I have a stacked-bar chart, it comprises data for profits of different months in recent years. The new data for september (9月) in 2013 is zero ($0.00), so the chart won't display anything for sep 2013.

But I still want it to display just the number $0.00 somewhere above the bar representing the August data in the 2013. How do I do that?



I tried manually adding a data label on the 2013 column, but it didn't work.
Someone already did that previously for Apr 2013.
Please take a look at the attached picture file.
Attached Images
File Type: jpg 圖片1.jpg (40.6 KB, 3 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform label bordercolor not controllable if click label skarden Word VBA 1 09-29-2013 07:27 PM
Word - Change Chart Colors Individually avalanche72 Word 0 09-18-2013 10:52 AM
Display a label character in a data cell markg2 Excel 9 09-07-2013 05:56 AM
How to add data label individually in a stacked-bar chart? chart from large data set mcfie Excel 1 09-19-2010 03:11 AM
Trying to merge label data from file ClayShannon Mail Merge 0 09-16-2009 10:08 PM


All times are GMT -7. The time now is 11:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft