Skip
##
18 posts tagged with Excel2007.

Posts

##
18 posts tagged with Excel2007.

Displaying 1 through 18 of 18. 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.

## 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]

## 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.

## 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]

## 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]

## 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]

## 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]

## 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.

## Filtering an Excel Spreadsheet

Problems filtering a large Excel worksheet that resides on a shared drive. [more inside]

## 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]

## Funnel Charts for Excel 2007?

Where can I download more attractive funnel chart templates for Excel 2007? [more inside]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

Page:
1