23 posts tagged with charts and graphs. (View popular tags)
Displaying 1 through 23 of 23. Subscribe:

Creating simple bar graph in Excel 2007

Hey guys, what I'm trying to do is very simple I just never really use Excel. I have two unrelated fields, categories, or columns, that I'd like to depict in a bar graph showing the amount of records that have been completed out of the total. The data are values, in my case "Yes", not numbers. I used the countif() formula to count every cell that has "yes". But I'm not really sure what I have to do next. Do I need to create another row showing what percentage this number is from the total amount of records, 136/633? And then create a bar graph from just that cell? When I just highlight all the cells for both columns and click bar graph it doesn't even fully show me a graph so I'm obviously not doing it right. Ideally, I'd like the y-axis to just show 0-100% and the total number of records(633) with marks maybe at 25% intervals. The x-axis to have my two column names and then the bars showing the percentage of records that have "yes" for these columns out of the total with a count included also. If anyone could help me out that would be great. Thanks a ton in advance.
posted by mr.coffee on Mar 28, 2014 - 6 answers

 

What is the point of a rose chart?

When is it more appropriate to use a rose (or radar) chart vs. a bar/line/pie chart? Bonus points if you can point to studies showing why some types of charts are better than others for understanding information. [more inside]
posted by nushustu on Oct 21, 2013 - 11 answers

Looking to extract more info from this database

We are storing information about application hits in a database. Sadly my database/excel skills are pretty limited and I'd like some help getting more info out of the information we have. [more inside]
posted by Admira on Jul 17, 2013 - 11 answers

OkCupid Blog RIP...

So I take it that the OkTrends blog was killed off after Match bought OkCupid. Where can I now get my regular fix of really interesting statistics presented at a level that the lay person can understand? (I already know about Nate Silver and xkcd's What If.)
posted by capricorn on Jul 7, 2013 - 6 answers

Chart help needed: How to show proportion between two values?

What type of chart do I want to show that one number is several times as many as another? [more inside]
posted by Sock Ray Blue on Jan 16, 2013 - 11 answers

Fast, Interactive Tcl Graphs

I'm looking for a good, simple plotting package. [more inside]
posted by DU on Aug 10, 2012 - 8 answers

Help me make my graphs pretty

Tips for making attractive charts/graphs? (In Excel/Illustrator, but I'm not bound to those). [more inside]
posted by hot soup on Jun 15, 2012 - 11 answers

Envisioning a syllabus on the Display of Quantitative Information

I am planning on teaching a course on data visualization to some Ph.D. students in the social sciences, and could use some ideas about designing the syllabus. If you have taken or taught such a course, I would especially value your input, but I would also love to hear from any among you who have experience doing data visualization. [more inside]
posted by rapidadverbssuck on Feb 14, 2012 - 8 answers

Looking for online tools for making nice data visualizations.

Are there online resources that will let an amateur make slick, professional infographics, graphs, charts or images+text? Or communities of designers that do quick, topical visualization challenges? Further details inside. [more inside]
posted by HE Amb. T. S. L. DuVal on Nov 8, 2011 - 2 answers

How Can I Make This Chart in Excel 2010?

Can you help me change the color on part of a chart in Excel 2010? [more inside]
posted by Bugbread on Apr 24, 2011 - 4 answers

Help me create a scatterplot that isn't ugly and bad

Better-looking scatterplot using data from an OpenOffice calc spreadsheet? [more inside]
posted by RobotHero on Feb 27, 2011 - 4 answers

DOUGHNUTS!

PowerpointN00Bfilter: How do I use the graphing functions in PP and Excel to simply display 2 columns showing two different values of x% of something? [more inside]
posted by broadway bill on Aug 1, 2010 - 2 answers

Please help me create charts to analyse my self-tacking data.

How do I chart my life? I'm using an Android App to input information against a date/time such as weight/mood/alertness/alcohol units etc. How can I easily view all this data on a big chart so I can see what relationships might exist? [more inside]
posted by razzman on Jul 19, 2010 - 6 answers

OMG, WTF, Wow.

I am blown away by this chart that TomMelee linked to here. [more inside]
posted by SLC Mom on Jun 19, 2010 - 7 answers

How do I graph/chart this information in a way that tells the whole story?

I need to graph/chart the information below, but I am not sure what format tells the whole story. Can you help? [more inside]
posted by laskagirl on Feb 10, 2010 - 10 answers

I've got brain freeze!

I need to design some really cool (elegant but very simple and clean) charts and/or graphs for a small brochure... any good resources you can point me to for inspiration? (Preferably websites, not books. I'm working on this tonight.) [more inside]
posted by miss lynnster on Sep 1, 2008 - 5 answers

Name that Chart!

Excel help: How do I make a chart which displays my values as bars extending above and below a particular line. [more inside]
posted by arcticwoman on Mar 9, 2008 - 12 answers

Fondness of O.P.P.

Can you help me find funny graphs/charts to show in my university level statistics class? They don't have to be technically correct, I just want something to put onscreen while the students are coming into class. Stuff like this is ok, but SFW is preferable.
posted by arcticwoman on Jan 24, 2008 - 22 answers

Easy way to make great-looking charts and graphs?

Elegant and simple way to create nice-looking graphs/charts from raw data? [more inside]
posted by jbickers on Dec 13, 2007 - 10 answers

What's the easiest way to converting raw numbers into a chart or graph?

What's the easiest way to convert this ungodly mess to a nice chart or graph? [more inside]
posted by JaySunSee on Oct 20, 2007 - 6 answers

3D Charts/Graphs in OSX

Help me create awesome 3D graphs/charts in OS X. [more inside]
posted by AMP583 on Oct 27, 2006 - 6 answers

Chart and graph software (not Excel)

I am looking for software that will generate charts and graphs that isn't Excel. [MI] [more inside]
posted by donovan on Feb 16, 2005 - 16 answers

How do I change the matrix of the legend in an Excel chart?

How do I change the matrix of the legend in an Excel chart? I have 1x6, and I want 3x2.
posted by trharlan on Nov 19, 2004 - 4 answers

Page: 1