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?
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]
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]
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.
I need to design a poster for my research project, and the majority of the content will likely be in the form of simple charts / diagrams / conceptual maps. I'm looking for examples of well-design posters that have multiple charts (ideally 2x2s). [more inside]
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]
Are there any websites or programs that can read and export MS Project .mpp files that are more affordable and just as capable as MS Project? Failing that, what's a good online website that can achieve the same effect of building the chart for the customer and maybe even allowing them to collaborate with us on it? We're a small company whose customers often like to see and modify MS Project files at the beginning of a project. Project is expensive and locked to one computer per license, and I don't feel like installing it on lots of computers here when most of the users will use it maybe 1% of the time. Plus, none of us know how to fully extract all the value from this expensive software to justify it. I'd like a solution more tailored to our small needs that still will satisfy our customers. I'm also open to other project management solutions as detailed below. [more inside]
I have been looking at Chartbuilder and d3.js as a means to generate chart images for clients. We make them a video and instream advertise it. We report monthly impressions and views of the video. What would be the best way to present this data? [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]
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]
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.)
Math-filter: I have a line chart in Google Docs that plots three columns of data over time. Data in the first two columns ranges from 0-1000, but data in the third column ranges from 3-9. I'd like to "scale" Line 3 (maybe this is the wrong word?) to be able to compare its value over the same graph space as Lines 1 and 2. [more inside]
At work we want to put up a certain type of pantone color chart on the website so that people can at least see approximate colors. I'm well aware of the issues with precise matching using a computer monitor; we just want to provide some general reference so that people can see what colors we're talking about if we give them a PMS number. [more inside]
Why would our Reverb Nation ranking drop a very lot in a very short amount of time? How does it work in general? What can I use to ensure our ranking best reflects our fan count or fan base on other sites - That's sort of the purpose of the band equity, I think, which - could someone explain it to me? What does it value? [more inside]
What type of chart do I want to show that one number is several times as many as another? [more inside]
How can I use PHP (ideally with jQuery) to generate charts like these that Wikipedia uses to show part shares in Congress?
You want to create a web dashboard with some pretty charts based on data in an existing MySQL database. What do you use? [more inside]
What's the easiest way to achieve this Reddit-lite interface? [more inside]
What Mac program should I use for a chart to keep track of my upcoming job applications? You know how in iTunes, you can see the same music library listed alphabetically by artist, or by album, or by genre, and so on? I'd like to be able to view the same bunch of jobs listed by deadline, or by ad number, or alphabetically by requirements. [more inside]
Why doesn't Obama or any politician for that matter use graphs to explain things? For all of their sophistication in Internet and social media, why doesn't the Obama campaign just go on television and show the American people a damn chart? Are we that stupid or am I missing something here?
I'm looking for a good, simple plotting package. [more inside]
Powerpoint Chart Colors Question: can someone tell me how to calculate the R/G/Y values for similar colors? [more inside]
Looking for a simple economic history chart to make a simple point. An hour on google images has failed me; can the hive mind help out? [more inside]
Tips for making attractive charts/graphs? (In Excel/Illustrator, but I'm not bound to those). [more inside]
What examples are out there on the web of interactive charts with thousands of data points that can be scrolled through smoothly with little interruption or skipping? [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]
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."
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]
This weekend I'm setting up a website for an academic event. I'd like the homepage of the site to have large, clickable progress bars that display the number of posts for each of the subpages (News & Announcements, Blog, Events, etc.). As more posts are added to each of the subpages (posts would likely be sorted and displayed by category and tag), its respective progress bar takes up more screen real estate and the tally count listed on/near it increases. Basically, I want the homepage to look like a giant, dynamic bar chart. Is there a freeware (or cheap) template, widget or piece of code that allows me to do this? [more inside]
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]
What are some super simple graph making programs? [more inside]
Best business charting software? [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]
Google Documents changed the way it handles chart data and now I can't make a simple graph. [more inside]
How does Apple calculate the iTunes App Store charts? [more inside]
Tell me about the most comprehensive diagram resources ever? [more inside]
What's the best Basecamp add-on for making Gantt charts? [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]
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.
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 was invited to a restaurant with a "Smart Casual" dress code and in my attempt to find out what that was I ran across this chart. I thought it was very clever and helpful and now I'd like to see more graphical representations comparing the various levels of dress codes. Have you seen any? Or do you know where I can find others?
How can I find sales stats and chart statistics for books released over the past 30 years? [more inside]
Excel charting help: Help me analyze sales stats based on salesperson tenure. [more inside]
Has someone made a list of all the types of charts/graphs/visualization types say from the books by Bretin / Tufte / Tukey etc? Wikipedia has something similar here: Diagrams or Charts. The idea is a simple list of graph names/techniques that one can quickly scan through while planning an infoviz. Anyone?
Looking for some good information on digital dashboards. [more inside]
Page: 1 2