Join 3,438 readers in helping fund MetaFilter (Hide)

9 posts tagged with graphs and excel. (View popular tags)
Displaying 1 through 9 of 9. 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

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

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

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

Rates of success?

Statistics question: is it possible to test sets of cumulative data for significant differences in rate? [more inside]
posted by rollick on Nov 4, 2009 - 9 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

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