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

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

Why can't MS just add a watermark function?

How can I add a watermark to multiple tabs of an Excel spreadsheet, that can be easily updated each time a copy is printed? [more inside]
posted by PercyByssheShelley on Dec 11, 2012 - 3 answers

I don't want to Excel, just get by...

My conditional formatting in Excel 2007 is at war with itself. Help me emerge the victor. [more inside]
posted by jph on Mar 8, 2011 - 11 answers

How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows?

How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows? [more inside]
posted by bottlebrushtree on Mar 5, 2011 - 7 answers

Excelfilter: XML Mapping gone wrong

Excel 2007 Filter: I need to convert a text file to XML. I have an existing XML file that has the correct schema, but no functional xsd file. How do I get the schema from the old file to map to the data in the new text file? [more inside]
posted by ashirys on Dec 2, 2010 - 1 answer

Filtering an Excel Spreadsheet

Problems filtering a large Excel worksheet that resides on a shared drive. [more inside]
posted by rhapsodie on May 17, 2010 - 7 answers

Funnel Charts for Excel 2007?

Where can I download more attractive funnel chart templates for Excel 2007? [more inside]
posted by thankyoumuchly on Apr 1, 2010 - 2 answers

Need help making an excel formula

Please bear with me, as I'm having difficulty wording this question. I'm trying to use excel to add values that belong to a list. Basically, the list has a entry, each entry has a value, and I want to total the values of like entries. [more inside]
posted by FireStyle on Dec 2, 2009 - 4 answers

I need help cleaning some dirty data

Excel-filter: Mysterious single-quotes that precede the data in each cell. How do I get rid of them? [more inside]
posted by ashirys on Mar 18, 2009 - 16 answers

Excel 2007: Filter one sheet based on a range of cells in another sheet

Excel 2007: How do I filter one worksheet based on values in a range of cells in a second worksheet. [more inside]
posted by syzygy on Aug 28, 2008 - 5 answers

Excel 2007 - Duplicate Data Removal Issue

Excel 2007 - Is there a way to remove ONLY a duplicate row leaving the first unique entry? [more inside]
posted by Sandor Clegane on Apr 16, 2008 - 5 answers

How can I conditionally format an entire row in Excel based upon the data in one of the columns in that row?

How can I conditionally format an entire row in Excel 2007 based upon the contents of a particular column in that row? [more inside]
posted by ChasFile on Feb 1, 2008 - 8 answers

Names as data labels or markers in Excel 2007?

Excel 2007 charting: Can you tell me how to use the name of a point as the data marker or the data label in an X-Y scatter plot? [more inside]
posted by muhonnin on Nov 28, 2007 - 4 answers

Page: 1