 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Graph Question
Hi I am using Excel 2000. I have created a 100% stacked column graph. I want to display the percentages on the face of the columns themselves. When I format the data series and go to data labels the show percent is greyed out. Probably because % is already shown on the Y axis. However, I also want them to be shown on the columns themselves. Can anybody help? Thanks Brendan Only a pie chart can show percentages when only the regular values are used to create the chart. Calculate the percentages in the worksheet, plot these, and your data labels will show percentages when you use the 'show value' option. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Hi > [quoted text clipped - 11 lines] > Thanks > Brendan Got it. Great, thanks. Brendan > Only a pie chart can show percentages when only the regular values are used > to create the chart. [quoted text clipped - 24 lines] > > Thanks > > Brendan What does one do if you require a table of the actual data and need the percentage values shown on the face of each bar? I need excel to calculate these percentages based on the hard data I have used as my graph's source data. Is there a way to do this? > Only a pie chart can show percentages when only the regular values are used > to create the chart. [quoted text clipped - 24 lines] > > Thanks > > Brendan As I said: >> Calculate the percentages in the worksheet, plot these, and your data >> labels >> will show percentages when you use the 'show value' option. This means you have two ranges, one with original values, which you can format nicely for the printed report, and one with percentages which you can move out of view but use for the chart source data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > What does one do if you require a table of the actual data and need the > percentage values shown on the face of each bar? I need excel to calculate [quoted text clipped - 32 lines] >> > Thanks >> > Brendan I was thinking more along the lines of using the 'show table' feature of the excel graph so that the colors on the graph correspond to the colors in the legend of the table beneath the graph. This is where I would like the actual data to appear and would like the %values to appear on the face. I think you answered my question though; this fairly simple task cannot be accomodated by Excel without a lot of manual manipulation (hint hint to MS). Thank you Jon :) > As I said: > [quoted text clipped - 49 lines] > >> > Thanks > >> > Brendan Those data tables are a royal pain, because you can't do much with them. If they do enough for you, construct the chart with the actual values, so the data table gets them right. Calculate the percentages as before in another range, then use one of these utilities to assign these calculated values to the points as labels: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ >I was thinking more along the lines of using the 'show table' feature of >the [quoted text clipped - 68 lines] >> >> > Thanks >> >> > Brendan |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.