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.
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]
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.
My conditional formatting in Excel 2007 is at war with itself. Help me emerge the victor. [more inside]
How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows? [more inside]
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]
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]
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.
Problems filtering a large Excel worksheet that resides on a shared drive. [more inside]
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]
Where can I download more attractive funnel chart templates for Excel 2007? [more inside]
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]
Does anyone have any tips or tricks for organizing information using Windows XP and MS productivity software? [more inside]
Excel-filter: Mysterious single-quotes that precede the data in each cell. How do I get rid of them? [more inside]
Excel 2007: How do I filter one worksheet based on values in a range of cells in a second worksheet. [more inside]
Excel 2007 - Is there a way to remove ONLY a duplicate row leaving the first unique entry? [more inside]
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]
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]