## 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?
posted by BuddhaInABucket on Feb 1, 2015 - 2 answers

## OCR for charts and graphs

This happens all the time in my work: I see a chart of valuable data, I want the exact numeric values or close approximations but the data is (purposely) unlabeled, or perhaps only key data is labeled. Is there a way to automatically estimate the values?
posted by 2bucksplus on Oct 13, 2014 - 11 answers

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

## What is the point of a rose chart?

When is it more appropriate to use a rose (or radar) chart vs. a bar/line/pie chart? Bonus points if you can point to studies showing why some types of charts are better than others for understanding information.
posted by nushustu on Oct 21, 2013 - 11 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.
posted by Admira on Jul 17, 2013 - 11 answers

## OkCupid Blog RIP...

So I take it that the OkTrends blog was killed off after Match bought OkCupid. Where can I now get my regular fix of really interesting statistics presented at a level that the lay person can understand? (I already know about Nate Silver and xkcd's What If.)
posted by capricorn on Jul 7, 2013 - 7 answers

## Chart help needed: How to show proportion between two values?

What type of chart do I want to show that one number is several times as many as another?
posted by Sock Ray Blue on Jan 16, 2013 - 11 answers

## Fast, Interactive Tcl Graphs

I'm looking for a good, simple plotting package.
posted by DU on Aug 10, 2012 - 8 answers

## Help me make my graphs pretty

Tips for making attractive charts/graphs? (In Excel/Illustrator, but I'm not bound to those).
posted by hot soup on Jun 15, 2012 - 11 answers

## Envisioning a syllabus on the Display of Quantitative Information

I am planning on teaching a course on data visualization to some Ph.D. students in the social sciences, and could use some ideas about designing the syllabus. If you have taken or taught such a course, I would especially value your input, but I would also love to hear from any among you who have experience doing data visualization.
posted by rapidadverbssuck on Feb 14, 2012 - 8 answers

## Looking for online tools for making nice data visualizations.

Are there online resources that will let an amateur make slick, professional infographics, graphs, charts or images+text? Or communities of designers that do quick, topical visualization challenges? Further details inside.
posted by HE Amb. T. S. L. DuVal on Nov 8, 2011 - 2 answers

## So how do people make those nice graphs?

What are some super simple graph making programs?
posted by boobjob on May 11, 2011 - 11 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?
posted by Bugbread on Apr 24, 2011 - 4 answers

## Help me create a scatterplot that isn't ugly and bad

Better-looking scatterplot using data from an OpenOffice calc spreadsheet?
posted by RobotHero on Feb 27, 2011 - 4 answers

## Diagrams - best of...

Tell me about the most comprehensive diagram resources ever?
posted by b33j on Sep 8, 2010 - 8 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?
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?
posted by razzman on Jul 19, 2010 - 6 answers

## OMG, WTF, Wow.

I am blown away by this chart that TomMelee linked to here.
posted by SLC Mom on Jun 19, 2010 - 7 answers

## How do I graph/chart this information in a way that tells the whole story?

I need to graph/chart the information below, but I am not sure what format tells the whole story. Can you help?
posted by laskagirl on Feb 10, 2010 - 10 answers

## I've got brain freeze!

I need to design some really cool (elegant but very simple and clean) charts and/or graphs for a small brochure... any good resources you can point me to for inspiration? (Preferably websites, not books. I'm working on this tonight.)
posted by miss lynnster on Sep 1, 2008 - 5 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.
posted by arcticwoman on Mar 9, 2008 - 12 answers

## Fondness of O.P.P.

Can you help me find funny graphs/charts to show in my university level statistics class? They don't have to be technically correct, I just want something to put onscreen while the students are coming into class. Stuff like this is ok, but SFW is preferable.
posted by arcticwoman on Jan 24, 2008 - 22 answers

## Easy way to make great-looking charts and graphs?

Elegant and simple way to create nice-looking graphs/charts from raw data?
posted by jbickers on Dec 13, 2007 - 10 answers

## What's the easiest way to converting raw numbers into a chart or graph?

What's the easiest way to convert this ungodly mess to a nice chart or graph?
posted by JaySunSee on Oct 20, 2007 - 6 answers

## 3D Charts/Graphs in OSX

Help me create awesome 3D graphs/charts in OS X.
posted by AMP583 on Oct 27, 2006 - 6 answers

## Chart and graph software (not Excel)

I am looking for software that will generate charts and graphs that isn't Excel. [MI]
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

Page: 1