| Thread | Last Post | Replies |
|
| NO REPEATS | 11 Jul 2008 21:55 GMT | 3 |
I have about 700 8 digit codes that are sorted numericaly. I received an additional 2,600. My problem is that some of these new #'s are repeats of my own. Someone told me to do a "V LOOKUP". What is that and how do I do it??????????
|
| Stacked Bar Chart | 11 Jul 2008 14:36 GMT | 3 |
I want to make a stacked bar chart using data from three columns. I want the first two numbers to stack and compare with the third column. Is that possible?
|
| Bars not showing up | 11 Jul 2008 14:35 GMT | 2 |
I am trying to create a bar chart that shows the square footage of particular buildings and when they expire. I have my X axis as the expiration years and the Y axis as the square footage. I cannot get each building to show up on my chart.
|
| Excel graph 3 sets of data. 2 sets as lines 1 as column? | 11 Jul 2008 13:18 GMT | 2 |
I have data a bit like below, I am trying to do a graph, which shows the AFR as columns for A-D, but I want 'water' and 'whole' as seperate lines to show current scores across the graph. When I do the graph, I get two columns and 1 line. Does anyone know how to get to get the two ...
|
| PivotTable Report - NEW USER | 10 Jul 2008 20:16 GMT | 1 |
I have a report with drop down boxes ("receiving issues") that several people are going to use and report certain issues they have with certain vendors. I need to do a PivotTable that will show a chart listing this information. I've never worked with a PivotTable and/or report ...
|
| Old-fashioned cross-hatching in bar chart (X-post) | 10 Jul 2008 19:34 GMT | 2 |
Gang, Just reposting this with a cross to the charting group. Sorry for the dupe in the Mac group... I need to format a black & white bar chart for a journal that strongly
|
| Data Range updating automatically as new data is entered | 10 Jul 2008 14:02 GMT | 1 |
Hi, I am wondering if there is a way to make the data range for a series graph include cells in a column up to the last nonblank cell? For example, I have a graph with a data range: =Sheet2!$B$2:$E$27
|
| Monthly Comparison By Year | 10 Jul 2008 12:45 GMT | 2 |
Is there a way to make a chart that compares the two same months of different years worth of data? For example, my spreadsheet has the date starting with January 2007 - June 2008 as the header listed in order. I have some charts built off
|
| Pivot Table to reference multiple sheets | 10 Jul 2008 01:10 GMT | 1 |
I need to create a pivot table that references the data from 2 worksheets. I have tried the consolidation method but am confused when the field list does not carry over my column names. Can someone please advise?
|
| how can I automate chart axes | 09 Jul 2008 15:17 GMT | 4 |
I'm generating chi-square charts that are dependent of the degrees of freedom and probability, hence each chart has a different shape. How can I automate the scales to be dependent on individual chi-squared data series. For example, if a series has DoF of 45 and I'm looking for ...
|
| Getting text and grid at a 45 degree angle | 09 Jul 2008 15:17 GMT | 5 |
I'm trying to create an affordance structure matrix (if anyone actually knows what that is!). It has a regular grid and then a grid above it, rotated 45 degrees. I know how to rotate the text, but that only gives me the grid lines for half of the grid. When I change the grid ...
|
| How do I set up a line - bar graph bar first and line all others? | 09 Jul 2008 15:14 GMT | 3 |
I trying to use the line - bar graph so that the current year is a bar and all other data sets are line, but the default for this chart type groups have of them as bars and half as charts. How do I get around this?
|
| Logarithmic error bar bug | 09 Jul 2008 11:26 GMT | 3 |
When placing error bars on a column graph with a logarithmic Y axis, the error bar is drawn as a large dark triangle connecting the last bar and it's neighbor. There is an error, something about negative and zero values in logarithmic scales, but there are no such values in the ...
|
| Pie of pie chart with 2 data series | 08 Jul 2008 23:21 GMT | 2 |
I am trying to process the results from a survey. For a particular question, the surveyed people can answer with (say) yes, no or partially. They also can justify their answer, with (say) something like cheaper, simpler or don't know. I would like to have a pie chart with the yes ...
|
| Dynamic Charts - Changing Number of Series | 08 Jul 2008 22:30 GMT | 3 |
I've read a lot of the entries regarding Dynamic Charts and think I understand it for a single Series, but I'm having trouble getting it to work when it's the number of Series that changes and the Category is static. I'm using a line graph (data sample below) for sales at ...
|