MS Graph Capability??

B

Brian Reilly, MVP

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
 
B

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
 
A

Andy Pope

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
 
B

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
 
B

Brian Reilly, MVP

'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"
 
A

Andy Pope

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
 
A

Andy Pope

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
 
B

Brian Reilly, MVP

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.
 
L

Lucy Thomson (aka aneasiertomorrow)

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
 
E

Echo S

"Lucy Thomson (aka aneasiertomorrow)"
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.
Click to expand...

God, I know that feeling!

--
Echo [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
 
B

Brian Reilly, MVP

Lucy and Echo,
Excel is really quite simple. There are only two things in it, rows
and columns.

Brian Reilly, MVP
 
G

Glen Millar

Brian,

And charts, and pivot tables, and, well, you are right. Rows and columns.

--

Regards,
Glen Millar
Microsoft PPT MVP

Tutorials and PowerPoint animations at
the original www.pptworkbench.com
glen at pptworkbench dot com
------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting the graph style I want 4
Dynamic graph 0
Plotting Graph with dynamic table 3
Two label categories on the Y-axis 1
iif exists - too complex? 0
Pie Chart will only Display one slice - 100% 1
How to draw out a bar chart backed by a 3-dimension database 3
code to copy range 1

Top