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

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

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]
posted by aught on Apr 3, 2014 - 1 answer

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

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]
posted by Admira on Jul 17, 2013 - 11 answers

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]
posted by undercoverhuwaaah on Jul 17, 2013 - 1 answer

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

What is this type of chart called and/or how do you create one in Excel? [more inside]
posted by tippiedog on Aug 17, 2012 - 8 answers

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."
posted by lassie on Nov 22, 2011 - 5 answers

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]
posted by mr_silver on Jun 30, 2011 - 12 answers

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]
posted by Bugbread on Apr 24, 2011 - 4 answers

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]
posted by broadway bill on Aug 1, 2010 - 2 answers

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]
posted by razzman on Jul 19, 2010 - 6 answers

How can I best visualize performance data by tenure?

Excel charting help: Help me analyze sales stats based on salesperson tenure. [more inside]
posted by samuelad on Mar 7, 2009 - 6 answers

Pie Chart Makeover?

Pie Chart Help. How do I make my pie charts look like this one? [more inside]
posted by kjars on Sep 23, 2008 - 6 answers

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]
posted by arcticwoman on Mar 9, 2008 - 12 answers

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]
posted by bubukaba on Jun 1, 2006 - 6 answers

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]
posted by Ritchie on Nov 30, 2005 - 3 answers

Chart and graph software (not Excel)

I am looking for software that will generate charts and graphs that isn't Excel. [MI] [more inside]
posted by donovan on Feb 16, 2005 - 16 answers

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.
posted by trharlan on Nov 19, 2004 - 4 answers

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]
posted by signal on Mar 24, 2004 - 11 answers

Page: 1