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? [more inside]
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.
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. [more inside]
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]
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.)
What type of chart do I want to show that one number is several times as many as another? [more inside]
I'm looking for a good, simple plotting package. [more inside]
Tips for making attractive charts/graphs? (In Excel/Illustrator, but I'm not bound to those). [more inside]
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. [more inside]
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. [more inside]
Can you help me change the color on part of a chart in Excel 2010? [more inside]
Better-looking scatterplot using data from an OpenOffice calc spreadsheet? [more inside]
Tell me about the most comprehensive diagram resources ever? [more inside]
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]
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]
I need to graph/chart the information below, but I am not sure what format tells the whole story. Can you help? [more inside]
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.) [more inside]
Excel help: How do I make a chart which displays my values as bars extending above and below a particular line. [more inside]
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.
Elegant and simple way to create nice-looking graphs/charts from raw data? [more inside]
Help me create awesome 3D graphs/charts in OS X. [more inside]
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? I have 1x6, and I want 3x2.