| Thread | Last Post | Replies |
|
| Pivot Table with Zero Values for Month | 14 Jan 2005 18:00 GMT | 1 |
I have a spreadsheet of information that lists problems experienced by 'application type' for each month in 2004. When I create a pivot from this data, where any particular 'application type' did not have a problem and, hence, no entry in the spreadsheet, the pivot does not ...
|
| Charting information from a number of worksheets | 14 Jan 2005 15:53 GMT | 1 |
I have a spreadsheet set up with one worksheet for each week of the year. The spreadsheets all have exactly the same template. I would like to plot a graph of the data held in cell B4 in all of the worksheets. I want to end up with a graph with the weeks across the bottom and ...
|
| Trendlines to ignore empty cells | 14 Jan 2005 13:32 GMT | 7 |
I have five years of data and the x axis is set for 6 years to allow the chart to fill up as new data is input. When I add a trendline it seems to include these empty cells. In fact, the cells contain a formula but have managed to get the data plot to not be zero by using the ...
|
| pivot chart format | 14 Jan 2005 13:19 GMT | 1 |
Dear experts, I am having problems trying to format the number for a pivot chart field, when I drop it on the x-axis of the chart. I have a certain format in my database, but when I create the pivot chart, this format is lost, and I can't
|
| How do I plot data by drilling down through sheets? | 14 Jan 2005 13:16 GMT | 2 |
I want to plot data down through sheets in stead of within a sheet. Quattro Pro allowed me to do this but can't figure how to do it in Excel
|
| hide column but show chart | 14 Jan 2005 09:50 GMT | 1 |
I use Excel 2003. I want to show people a chart from an Excel sheet on my computer. These people will only come and watch what I show them on the monitor but will not receive my Excel file.
|
| bar, line and cumulative bar graph in one chart | 14 Jan 2005 08:05 GMT | 2 |
Hi I was making a dashboard chart which has a gropup of 4 bar graphs, showing 3 parts each and a line graph ....for 10 issues. Please suggest
|
| Watermark for Excel chart | 14 Jan 2005 02:21 GMT | 1 |
Does anyone know how to create a watermark on an Excel Chart?
|
| How do I customize the X-axis in excel to match my dataset? | 14 Jan 2005 01:25 GMT | 1 |
I am trying to my x-axis to match my dataset. The axis is tied to a monthly sampling event, however the events do not occur every 30 days. I want my first point to match the first sample date, and so-on. Thanks!
|
| Text box in Excel Chart | 14 Jan 2005 00:59 GMT | 3 |
I am unable to place a textbox into an Excel chart plot area and have it remain visible when the textbox in un-selected. Cannot view, does not show up in Print preview unless I click outside of the chart in some cell. Have tried "draw/order/bring to front"
|
| Combining Information in a Bar Chart | 13 Jan 2005 20:55 GMT | 4 |
I'm using Office XP - Excel 2003. I'm creating a bar chart by year. Each year has four separate values. The values are LOI Received; LOI Invited; Proposals Received; Grants Awarded. The LOI Invited value is a part of the total amount for LOI Received. For
|
| Column A is Town, Column B is names. How can Excel add & tell how. | 13 Jan 2005 19:27 GMT | 3 |
Column A is Town, Column B is names, Column C is how many in each household. How can Excel add & tell me how many Smiths in each town and, if possible, how many Smith families with 2 people in each town. Then I want to chart the info. How many of each family name by town.
|
| Triangular Coordinates | 13 Jan 2005 16:52 GMT | 6 |
Can someone point me to a routine that will plot my data on triangulat coordinates? TIA AL
|
| Logarithmic Trendline Equation | 13 Jan 2005 11:55 GMT | 2 |
I have a logarithmic trendline with the equation Y = 533371Ln(x) - 3E+06 associated with a line series. I want to create another series using this equation (substituting 1, 2, 3, etc. for x) but don't know what "3E+06" means, or how to set the equation up as a formula. Can ...
|
| How do I add a bullet to a note on an excell graph. | 13 Jan 2005 09:24 GMT | 2 |
I have created a text box on and excell graph with a note in side and want to add some bullets in front of a couple of items in the text box.
|