##
19 posts tagged with excel *and* charts.

Displaying 1 through 19 of 19. Subscribe:

## How to split a line chart by day of the week

ExcelFilter: I have two columns of data- column one is every day in a month, column two is attendance. I'd like to have a line graph that shows the data split into 7 lines- one for Mondays, one for Tuesdays, etc. How can I do this?

## Getting crazy duplicate charts in Excel spreadsheets using Save to Web

So, I have a series of worksheets in an Excel file that I routinely save to web (single web page format) so that colleagues can access the information on an intranet. Since our company upgraded to Office 2010 these worksheets have begun accumulating multiple copies of any charts located on these sheets (superimposed on the original) - these duplications are in both chart and image form. [more inside]

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

## Looking to extract more info from this database

We are storing information about application hits in a database. Sadly my database/excel skills are pretty limited and I'd like some help getting more info out of the information we have. [more inside]

## Excel Chart Coloring Issues

I've got three pie charts in excel that show the same cut of information (location of sales) for three time periods: current month, current year YTD, last year YTD, with each chart fed by tables that rank locations by total sales for each time period. I want the color for any given location to be the same in each chart, regardless of its rank for each of the three time periods. How do I do that? [more inside]

## What is this type of chart called and/or how do you create one in Excel?

## Free online graphing app that plays well with Excel?

Asking for a colleague:
"Back in October 2008, I found a free online app that uploaded data from Excel and produced (very pretty) charts and graphs. Unfortunately, I didn’t keep track of the website, and I’m having trouble tracking it down again. Most of the free graphing apps I’ve found online today require that you manually input the data; I’m looking for something that will more easily upload a set of data from Excel."

## Can I get anything useful out of my savings history?

As a result of my method for saving money, I've ended up with a huge excel spreadsheet for the last 4 years detailing how much I've put in and taken out of my savings account. The problem is that although I've taken time to record all this information, I've now realised that I'm not sure what I can actually do with it. Do you have any ideas? [more inside]

## How Can I Make This Chart in Excel 2010?

Can you help me change the color on part of a chart in Excel 2010? [more inside]

## DOUGHNUTS!

PowerpointN00Bfilter: How do I use the graphing functions in PP and Excel to simply display 2 columns showing two different values of x% of something? [more inside]

## Please help me create charts to analyse my self-tacking data.

How do I chart my life? I'm using an Android App to input information against a date/time such as weight/mood/alertness/alcohol units etc. How can I easily view all this data on a big chart so I can see what relationships might exist? [more inside]

## How can I best visualize performance data by tenure?

Excel charting help: Help me analyze sales stats based on salesperson tenure. [more inside]

## Pie Chart Makeover?

## Name that Chart!

Excel help: How do I make a chart which displays my values as bars extending above

*and below*a particular line. [more inside]## Visual data organization.

I would like to make a chart like this to track my daily computer usage. Any ideas on how I could do this? Any free software you can recommend? Any way of doing it with Excel? [more inside]

## Custom PivotChart reverts to standard type when modified

In Excel 2002 when I create a PivotChart and apply a custom or user-defined chart type (in this instance a 2-axis line chart), the chart type reverts to a standard single-axis line chart whenever I modify one of the PivotFields. How do I prevent this? [more inside]

## Chart and graph software (not Excel)

I am looking for software that will generate charts and graphs that isn't Excel. [MI] [more inside]

## How do I change the matrix of the legend in an Excel chart?

How do I change the matrix of the legend in an Excel chart? I have 1x6, and I want 3x2.

## Other than Excel, Freehand, and Illustrator, are there any really snazzy looking, easy to use charting apps for XP?

I need to create some charts (as in bar-, pie-, etc.) for a presentation. I have used Excel (easy but boring), Illustrator and Freehand (slightly more complicated and exciting) for this in the past, but want to expand my repertoire. Are there any really snazzy looking, easy to use charting apps for XP? [more inside]

Page:
1