 |
 | 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 / New Users / August 20070 values on pie charts
I am working in Excel 2007 and have many pie charts. I have 2 issues I would like help on. 1. I want the values of the data to display on the pie chart but this puts 0 for all the 0 values in the data. This might be fixed if I can figure how to get question 2 to work. 2. I set up a column beside each data column for the values that don't have 0 in them to display =IF(C150<>0,A150,"") This take the text off of the chart but leaves the color swatch. Thanks for the help You can apply autofilter just to cover the range of your data (plus heading). Assume this is C149:C160, then highlight this range and Data | Filter | Autofilter (check). Now from the filter pull-down select Custom... and set it to Does Not Equal then 0 (zero). This will hide the rows with zeros in, and consequently the Legend entries for those items. Hope this helps. Pete > I am working in Excel 2007 and have many pie charts. I have 2 issues > I would like help on. [quoted text clipped - 8 lines] > > Thanks for the help Change your formula to =IF(C150<>0,A150,#N/A) Now you can use conditional formatting to hide the #N/A's if you want to...  SignatureHTH... Jim Thomlinson > I am working in Excel 2007 and have many pie charts. I have 2 issues > I would like help on. [quoted text clipped - 8 lines] > > Thanks for the help On Aug 29, 8:32 am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- This-.com> wrote: > Change your formula to > =IF(C150<>0,A150,#N/A) [quoted text clipped - 4 lines] > > Jim Thomlinson I keep seeing that you can hide items using conditional formatting but all I see is changing color or basic stuff. How do I hide cells based on conditional formatting. My data is complex: BILL BOB JOHN Activator 4 Composer 1 Composer 1 Gateway 3 Gateway 7 Gateway 12 Integrator 2 PassPort 3 Sentinel 5 CFT 5 If I hide cells will it mess up the data You can "hide" an error by selecting white fonts thus making it impossible to see the value in the cell itself (of course in the formula bar it will still be visible), That was what Jim meant You need a macro to hide cells SignatureRegards, Peo Sjoblom > On Aug 29, 8:32 am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- > This-.com> wrote: [quoted text clipped - 29 lines] > > If I hide cells will it mess up the data I was (in my mind anyway) alluding to using conditional formatting to hde error values. Check out this link... http://www.contextures.com/xlCondFormat03.html#Errors SignatureHTH... Jim Thomlinson > On Aug 29, 8:32 am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- > This-.com> wrote: [quoted text clipped - 28 lines] > > If I hide cells will it mess up the data On Aug 29, 12:48 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- This-.com> wrote: > I was (in my mind anyway) alluding to using conditional formatting to hde > error values. Check out this link... [quoted text clipped - 39 lines] > > - Show quoted text - Now that conditional formatting is out is there a way to display the values on the pie chart but if the value is 0 don not display the category or 0 value on the pie chart. I found something earlier but don't quite understand how it works because it uses range names. I know that range name can be created but usually when you select the range it diplays the range name in the upper left hand corner where the cell name is displayed by default. This is the example I found http://www.andypope.info/charts/piezeros.htm if someone could help me understand what and how Excel is doing that would help me a lot. I am also researching this on my own and will post my finding. Thanks Ken You seem to have overlooked my earlier posting - have you tried it? It works for me. Pete > On Aug 29, 12:48 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- > [quoted text clipped - 57 lines] > > - Show quoted text - > You seem to have overlooked my earlier posting - have you tried it? It > works for me. [quoted text clipped - 64 lines] > > - Show quoted text - I had to rearrange most of my data to use this method but this seems the easiest to do. I thank you for all your help. A quick note: If you want to use this method on several pieces of data you will have to put them in the same column and run the filter on all of them as you can only have one filter on a column. Thanks for feeding back - glad you got it to work. Pete > > You seem to have overlooked my earlier posting - have you tried it? It > > works for me. [quoted text clipped - 72 lines] > > - Show quoted text - > Thanks for feeding back - glad you got it to work. > [quoted text clipped - 78 lines] > > - Show quoted text - One more little problem which may only be fixable with a macro I have 12 team members and each on has a pie chart. Is there a way to have AMTrix always be say blue even if it is not present in the chart data so we can have consistant chart colors? Bob product Num of tickets open Activator V4 AMTrix Composer 1 FTPCS Gateway 5 Gateway Interchange Integrator 1 PassPort Jim Activator V4 AMTrix Composer FTPCS Gateway Gateway Interchange 10 Integrator 2 I don't know of a way to do that - I think Excel allocates the colours it uses from a sequence (which you can change), so the second visible slice of the pie chart will be whatever the second colour in its sequence is. Obviously in your case the second visible slice will not always relate to the same product for each team member. Pete > One more little problem which may only be fixable with a macro > I have 12 team members and each on has a pie chart. Is there a way to [quoted text clipped - 20 lines] > Gateway Interchange 10 > Integrator 2 |
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.