 |
 | 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 / General PowerPoint Questions / November 2007MS Graph Capability??
Hi all you wonderful people, As an MVP, I have answered a lot of questions here over the years. Now, it is your turn to answer and teach me something. It involves MS Graph vs. Excel charting. First, you all know I prefer making charts in Excel. That bias aside, I would like to know if this is possible in MS Graph? Assume you have multiple levels of what I call X-axis labels and want to summarize that within their own data segments. Let's assume you have data that reports Total Tried for then entire data and sub sets of Male or Female (Call that Gender), and then age groups, being Age 21-29, 30-40, 50+. The chart I would like in MS Graph, which I can do in the blink of an eye in Excel, would have the X-Axis have two levels of text (showing what was for Total Tried and the next level for Gender and next for Age, and then the other sub-sets, e.g. Male/Female and Age, e.g (21-29) etc. I could supply a simple file by email if necessary that shows that in Excel. But does anyone think this is possible in MS Graph or not? Love this group. We all learn something every day. Brian Reilly, MVP Aw, Come on folks Echo says this can't be done in MS Grump. I believe her. But somebody must know a way to do this. Without using Excel! (vbg) Echo is the best MS Grump chartie that I know, I don't use it and won't, but any other other comments on this issue? I'm just looking for a Yes/No answer. Brian Reilly, MVP You need to post an image of the chart you're thinking of. It's hard to envision based on just a description.  SignatureEcho [MS PPT MVP] http://www.echosvoice.com What's new in PowerPoint 2007? http://www.echosvoice.com/2007.htm (New!) The PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/2qzlpl Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/index.html > Aw, Come on folks > [quoted text clipped - 6 lines] > > Brian Reilly, MVP Hi Brian, Assuming what you are trying to achieve is 2 rows of axis labels I think the answer is no. It would appear the data sheet restricts series and category text to the 1st row and or column. You could use the data labels of a second data series and position them in the center of your groups. If you want to send the file just to confirm please do. email addy is andy AT andypope DOT info Cheers Andy SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info > Aw, Come on folks > [quoted text clipped - 6 lines] > > Brian Reilly, MVP Andy, As you have said, sometimes Excel is just too easy to be a challenge. I can do it there easily and would never consider using MS Graph. Unless the customer had LOTS of money for trying stuff like this. I'll send you the Excel file which has the data in a worksheet and the chart is just created on the same worksheet from that sourcedata. Only real trick is to make sure the data has no "0" values in axis (must be cleared, oh you knew that I know). Thanks for having a peek at this. Echo has already seen the file and says she knows of no way to do this in MS Grump. Nice of you to stop bye here now and again. Your inputs are always welcome and always brilliant. Brian Reilly, MVP >Hi Brian, > [quoted text clipped - 11 lines] >Cheers >Andy 'To complete this thread, Andy Pope, a super XL MVP came up with an "almost" solution done iin MS Grump. Still couldn't get the decender lines I need that XL does natively. Was a valient try. They shoot Horses, don't they. Don't shoot Andy, he's a good guy. Just shoto MS Grump. Thanks Andy, You show up here any time you get bored with the simplicity of XL (vbg) Brian Reilly, MVP To complOn Tue, 27 Nov 2007 10:00:03 -0000, "Andy Pope" <andy@andypope.info> wrote: >Hi Brian, > [quoted text clipped - 11 lines] >Cheers >Andy Hi Brian, Thanks for the kind words :) I did have another bash at the chart in order to get those descenders. Still not 100% but much closer to the xl version. Cheers Andy > 'To complete this thread, Andy Pope, a super XL MVP came up with an > "almost" solution done iin MS Grump. Still couldn't get the decender [quoted text clipped - 26 lines] >>Cheers >>Andy Can you do it manually, or are you guys crunching code? SignatureEcho [MS PPT MVP] http://www.echosvoice.com What's new in PowerPoint 2007? http://www.echosvoice.com/2007.htm (New!) The PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/2qzlpl Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/index.html > Hi Brian, > [quoted text clipped - 34 lines] >>>Cheers >>>Andy Hi Echo, For proof of concept I created the graph manually. This just involved setting the text and position of the data labels used to mimic the axes labeling. If required this could be automated. Cheers Andy > Can you do it manually, or are you guys crunching code? Ah. I was thinking more about the pipes between axis labels and the 2nd level of axis labels. I don't know that I could do those manually in MS Graph. SignatureEcho [MS PPT MVP] http://www.echosvoice.com What's new in PowerPoint 2007? http://www.echosvoice.com/2007.htm (New!) The PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/2qzlpl Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/index.html > Hi Echo, > [quoted text clipped - 6 lines] > >> Can you do it manually, or are you guys crunching code? Echo, Andy Pope, XL MVP) has done a wonderful job that requires the usual full moon stuff to make it work, unlike XL which does it natively. I'll send you the file. The data sheet is a hoot. Owls will screech when you see it. Andy, you and Jon Peltier always amaze us by your grasp of the charting engine. And I hold Echo way up there with you. Well above me. But, I'm still stickin with XL since it is natively built into the XL chart engine. >Ah. I was thinking more about the pipes between axis labels and the 2nd >level of axis labels. I don't know that I could do those manually in MS >Graph. Hi all I just wanted to echo Brian's praise of Andy Pope & Jon Peltier - you guys rock. And it's so great not having to learn everything about charting myself in order to answer the odd odd client question ;-) I love excel but my brain isn't really big enough for it. Lucy SignatureMOS Master Instructor www.aneasiertomorrow.com.au > Echo, > Andy Pope, XL MVP) has done a wonderful job that requires the usual [quoted text clipped - 11 lines] > >level of axis labels. I don't know that I could do those manually in MS > >Graph. > Hi all > [quoted text clipped - 4 lines] > > I love excel but my brain isn't really big enough for it. God, I know that feeling! SignatureEcho [MS PPT MVP] http://www.echosvoice.com What's new in PowerPoint 2007? http://www.echosvoice.com/2007.htm (New!) The PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/2qzlpl Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/index.html Lucy and Echo, Excel is really quite simple. There are only two things in it, rows and columns. Brian Reilly, MVP On Wed, 28 Nov 2007 14:27:01 -0800, Lucy Thomson (aka aneasiertomorrow) <LucyThomsonakaaneasiertomorrow@discussions.microsoft.com> wrote: >Hi all > [quoted text clipped - 5 lines] > >Lucy Brian, And charts, and pivot tables, and, well, you are right. Rows and columns. SignatureRegards, Glen Millar Microsoft PPT MVP Tutorials and PowerPoint animations at the original www.pptworkbench.com glen at pptworkbench dot com ------------------------------------------ > Lucy and Echo, > Excel is really quite simple. There are only two things in it, rows [quoted text clipped - 16 lines] >> >>Lucy
|
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.