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

18 posts tagged with Excel2007. (View popular tags)
Displaying 1 through 18 of 18. Subscribe:

Related tags:
+ (13)
+ (6)


Users that often use this tag:
ashirys (2)

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

How can I create an Outlook task in Excel 2007?

How can I create an Outlook task in Excel 2007? This seemed to have been fairly straightforward in Excel 2003, but I can't for the life of me locate this feature (if it still exists) in Excel '07, and my Google-fu has failed me.
posted by El Sabor Asiatico on Jun 5, 2012 - 6 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

Excel 2007 is automatically inserting decimals into my numbers. Help!

When I enter numbers in an Excel 2007 spreadsheet, it automatically inserts a decimal before the final digit. How can I STOP it from doing this? [more inside]
posted by hurdy gurdy girl on Sep 26, 2010 - 7 answers

How do I make this chart in Excel 2007?

Can you help me turn this data into a graph that looks like this in Excel 2007. The chart is from SPSS, but the formatting is awful and you can only export the file in picture format. Thank you.
posted by Blacksun on May 20, 2010 - 3 answers

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

Where's the report filter value?

Excel2007EmergencyFilter: Is there a way to get my filter value on a Pivot Chart to show up on the actual chart, like it did back in good ol' Excel 2003? [more inside]
posted by undercoverhuwaaah on May 16, 2010 - 1 answer

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

tips or tricks for organizing information using Windows XP

Does anyone have any tips or tricks for organizing information using Windows XP and MS productivity software? [more inside]
posted by KokuRyu on Apr 8, 2009 - 7 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