Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Check out Omnigraph Sketcher....

http://www.omnigroup.com/applications/omnigraphsketcher/

It gives you more control over the graphs you make. You can literally sketch the axis and add the points to the graph manually, if you want. Or you can import data from Excel, make the graph, and then manually edit.

This is also great if you want to make a sketch for a presentation that shows a theoretical curve, rather than based on actual data.
Excel as a graphing/charting app is a very blunt instrument. Dedicated charting apps are far superior. OmniGraphSketcher's forté is not graphing Excel data; its forté is generating graphs that look like the work of a professional graphic artist. At $29.95, it is one of the best bargains in the professional software market. If graphing Excel data is your intent, then DeltaGraph is the traditional choice. Its graphs are probably the best combination of design aesthetics and technical precision on the market.
 
Excel as a graphing/charting app is a very blunt instrument. Dedicated charting apps are far superior. OmniGraphSketcher's forté is not graphing Excel data; its forté is generating graphs that look like the work of a professional graphic artist. At $29.95, it is one of the best bargains in the professional software market. If graphing Excel data is your intent, then DeltaGraph is the traditional choice. Its graphs are probably the best combination of design aesthetics and technical precision on the market.

DeltaGraph is very good, and has by far the most charting options. OmniGraph Sketcher is more than enough to handle the issue brought up by the original post.
 
Turn horizontal bar graph to vertical bar graph

Does anyone know how to turn an Excel for mac 2008 horizontal stacked bar graph to be vertical?

This is so lame :-(
 
Does anyone know how to turn an Excel for mac 2008 horizontal stacked bar graph to be vertical?

Select your data, choose the Charts tab in the Document Elements Gallery (that's the tabs below the toolbar), click on "Column", and finally choose the bar graph style that you want.

Regards,
Nadyne.
 
I have FINALLY figured this out after an hour of struggling and vowing to kill everyone at microsoft and mac.. The solution is so simple. Don't make a line graph, make an XY scatter plot. Wala, its done. I feel proud of myself.
 
Making any sort of chart in excel 2008

I'm trying to figure out how to make a chart. An example of what I need would be, I would like to know how many in column A uses the item in row 1P.
When I try to make the chart, what comes up is all the info in column A becomes the legend and there is nothing to tell me what I need.

I hope this is explained well enough to get me some help.

And I'm sure it doesn't mean anything (I hope it doesn't), but I'm using ★s to identify which line in column A uses whatever that's in row 1.

Thanks

JB :apple:
 
If you happen to find that our help isn't helpful, please tell us what would better help you out. At the bottom of every help page in Office 2008, there's a question asking whether this topic helped you. When you click on an answer, you can give more information about it.

Your comments are sent directly to our help team, and they monitor those comments to see what kinds of changes that they can make to improve the help. We're continually publishing new and updated help for Office 2008, as well as determining what changes we need to make to the help for the next version of Office, so this is hugely useful to us.

Regards,
Nadyne.

I think first of all, what CAUSES a need for Help so much is that the Mac versions of Office are literally retarded compared to the PC version.

Of course Apple's look and feel is a bit different, and they put some restrictions on menu organization. But WHY THE HELL is Office so different? Almost all the keyboard shortcuts disappear-WHY?!?!?! Many of the basic structures of how things work are all discombobulated (why does formatting which X, Y, and name data feed a graph look totally different? I can't find anything).
I believe the vast majority of Mac Office users are also using it under Windows at work-and that's why we have it on our Mac!-so it is senseless for everything to be so different. If it was the same, maybe we wouldn't need Help so much in the first place.

Before, I didn't mind too much paying Microsoft so I could have the same thing at home and work. But it's become so divergent, I'm feeling OpenOffice on my Mac might be a better match for the Excel on my PC. No, really, I mean it.

As for how could the Help be better...I don't know. I suspect the others here don't either. It just seems like many queries I type don't really come up with any information, and many terms are no longer in the index. This is especially true if no Internet connection is available.
(I just typed "data series" and "series data" into Help. No matches. Typical. Also "axis labels"-no matches. That's RIDICULOUS, those are basic graphing terms!)
 
I have FINALLY figured this out after an hour of struggling and vowing to kill everyone at microsoft and mac.. The solution is so simple. Don't make a line graph, make an XY scatter plot. Wala, its done. I feel proud of myself.

Oh, BLESS YOU for posting that!!!!

btw, I think you mean "Voila!" ;)
 
Excel naming graph help

I've been working on an apartment graph showing rents vs. time of year. How do I change the name of the line item from series 1 to monthly rents?
 
use scatter graph!

atruenut you are right highlight all your data series and click scatter graph. It will label the axis correctly (for me anyway) and then you can turn the scatter graph into any other graph format you want! GOOD TIMES
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.