| Thread | Last Post | Replies |
|
| plotting data from column next to chart area | 21 Nov 2006 01:58 GMT | 1 |
my data look like this: Colum 1 - 2 - 3 - 4 personX - age - job level - salary I want to plot on X the age, on Y the salary, and I want the plots in a
|
| Data Lables, series and Scatterplots | 20 Nov 2006 22:50 GMT | 2 |
Is there any way to get excel scatterplots to recognize a third column (or row) as a series for a scatterplot? FOr example I have data as: Sequence Long Lat 1 49.12 28.05
|
| eliminate zero value cells from a chart in Excel | 20 Nov 2006 20:34 GMT | 1 |
I am trying to chart a series of data that has some zero value cells. I don't want the chart to pick up zero value but rather treat them as a blank cell. Any idea how to do that?
|
| Showing Data Labels with 0 as blank | 20 Nov 2006 18:05 GMT | 4 |
When selecting Values for Data Labels, is there a way to make the label associated with a column/bar that has a zero value display as blank rather than “0”? Any help would be greatly appreciated.
|
| Replace numbers on x-axis of scatter chart with text eg 1 - one | 20 Nov 2006 17:42 GMT | 3 |
I want to replace numbers on the x-axis of a scatter plot with text labels.
|
| How do I show the whole chart? | 20 Nov 2006 08:23 GMT | 1 |
All of my values in my graph are negative, so my chart only shows the 3rd quadrant, but I'd like to make my graph show all four quadrants. Any suggestions?
|
| Drawing an Age Pyramid | 19 Nov 2006 18:43 GMT | 4 |
How do I draw a gender-disaggregated age pyramid using MS Excel
|
| Pivot tables with pre-counted dates | 19 Nov 2006 14:17 GMT | 1 |
I wish to build a pivot table, based on a simple data sheet, with the following columns: a) name b) type
|
| Display Date on Chart | 18 Nov 2006 18:41 GMT | 11 |
Is there a way to link a chart to a cell on a spreadsheet that contains the date? What I want to do is generate weekly charts on production data, and pick up the date that's put in a cell and display it either in the chart title or near it.
|
| Gantt Chart | 18 Nov 2006 13:38 GMT | 1 |
Good morning, I wanted to create a small Gantt chart via Excel using conditional formatting with weeks instead of days. Everything seems to be working fine except when a project starts and finishes within the same week. It doesn't
|
| excel chart to tiff or eps format | 18 Nov 2006 05:22 GMT | 1 |
I have created several detailed charts in excel for a paper that I am sending to a journal. The journal requires that my files have eps or tiff extensions. How do I convert the excel chart into tiff or eps? I have tried to 'print' to tiff with microsoft office document image
|
| Display Error Bar values on chart? | 18 Nov 2006 05:19 GMT | 1 |
Is there a way to display the error bar values on a chart (similar to how you display the data point value)? Thanks. John
|
| Different X-axis labels for different Series in same chart | 18 Nov 2006 05:17 GMT | 2 |
Is there a way for me to make the X-axis reflect different labels for a 2nd and 3rd series in the same chart. In the 1st series when I put in the value for the X axis, I have it show this value in the data label and not along the bottom of the chart. I want to do the same thing ...
|
| Chart Copying Issue | 18 Nov 2006 03:09 GMT | 2 |
Please help my boss's boss with this: 1) Select whole page, including chart 2) Copy 3) Open new workbook
|
| Pivot Table not populating cells | 18 Nov 2006 01:11 GMT | 1 |
I have a set of data which I need to put into a PT: Level 1 is Surname and level 2 is First Name. I've sorted it within the PT by Surname then First name. I have 15 instances of the name Jones. When the PT is produced it only shows one instance of th word Jones and then the ...
|