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.
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]
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."
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]
Can you help me change the color on part of a chart in Excel 2010? [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]
Excel charting help: Help me analyze sales stats based on salesperson tenure. [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]
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]
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]
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.
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]