| Thread | Last Post | Replies |
|
| Combine data in one bar for a PIVOT bar graph | 24 Oct 2006 14:09 GMT | 2 |
My COLUMN Headings are as follows: Month-Day-Date-Sales-Discounts-Net, where Day is the day of the week, Mon. Tues. etc. I want my Page tabs in the Pivot Chart to be Month and Day.
|
| Pivot Table Formatting | 24 Oct 2006 01:00 GMT | 1 |
I am trying to customize the format of both a pivot table and pivot chart (color, line width, etc.) and have the format remain upon refreshing the data. Basically, I want to make this custom color design the default formatting for tables and charts. Does anyone know if this is ...
|
| Don't Show Zero Data | 23 Oct 2006 23:31 GMT | 1 |
Is there a way to not show data on a bar chart if the data is =to Zero. (e.g.) Name: Amount: Almond Cream Cake 0 Apple Strudel 3
|
| Macro Help | 23 Oct 2006 22:54 GMT | 1 |
I know very little about VBA coding. I found an event macro in another thread on this board to enter a date/time stamp in a cell when a chanage was made in a range of cells. The code was written for a range that was a single column and used .offset(0,1) to determine where the ...
|
| How do I edit label when cursor is placed on trendline in excel? | 23 Oct 2006 22:48 GMT | 1 |
When you place a cursor on a trendline you get a data label with name and point position. How do i edit what is displayed here- either htrough excel or using VBA?
|
| graphing dates | 23 Oct 2006 17:24 GMT | 2 |
I'm trying to graph these dates; 9/1 9/5 9/6
|
| REGRESSION ON EXCEL | 23 Oct 2006 12:43 GMT | 2 |
How do you go from a chart with information to a line of regression on excel?
|
| Chart creation | 23 Oct 2006 03:17 GMT | 2 |
I am currently using Excel 97, which has been great. I have been requested to change a chart that has been created. The chart is a bar chart and has a secondary access. So on side is the number of people and the other side is a percentage of attendance.
|
| bar chart | 22 Oct 2006 17:45 GMT | 3 |
I am trying to make a bar chart. My problem is that excell keeps combining info from 2 different projects and inserts both of them into one bar chart. How do I fix this problem?
|
| Delete old chartobject and create a new named one? | 22 Oct 2006 13:30 GMT | 2 |
I need a subroutine that delete the old chartobject in a worksheet, create a new chartobject , name it as I want. Reason is that if the user delete the chart, I want to recreate it. I know how to protect it but feel that the user had to be able to change
|
| Entering an address in one cell | 21 Oct 2006 22:20 GMT | 2 |
I am trying to put together a mailing list. I've created a table and want to place customer addresses in corresponding cells. When I enter their addresses and hit the Enter key, the different lines of the address don't automatically shift to the next line. How do I do that so ...
|
| Combination chart: 3 stacked columns + 1 line | 21 Oct 2006 16:06 GMT | 1 |
Wanted to know if anyone has done this successfully: 3 stacked columns with a separte data series as a line. I am finding that you can do a combination with: 2 stacked columns but not 3. BTW: read 6/5/06 posting with Andy Pope response but did not address 3
|
| Non numeric axis vs non-numeric axis | 21 Oct 2006 16:04 GMT | 1 |
I need to graph the months on y-axis and region names on x-axis and then plot a numeric value in the plot area. For some reason I cannot make it work. Any suggestions?
|
| Can you change the color of only one axis line? | 21 Oct 2006 13:45 GMT | 1 |
Is it possible to change the color of just one axis line on a chart? It would be nice because then we could mark in red which would allow us to see target values we are shooting for and then see how the actual results measure up.
|
| "create chart" is not active | 21 Oct 2006 13:35 GMT | 1 |
I want to create a chart but the chart functions are not active. What could be causing this?
|