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]
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]
Problems filtering a large Excel worksheet that resides on a shared drive. [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]
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]