| Thread | Last Post | Replies |
|
| excel chart - sales data for 3 years | 11 Mar 2004 15:35 GMT | 1 |
Hi i need help to creat a weekly sales graph for 3 years. I have complete weekly data (52 weeks) for year 2002 and 2003. Now current year 2004 sales come in on a weekly basis. Here is what I need: 1. A triple line graph with dollars on X-axis and week number and
|
| Saving a Chart as JPEG | 11 Mar 2004 14:18 GMT | 2 |
I have a chart in Excel that I need to save as a JPEG image, and I was wondering how to go about doing that. I have Office 2000. Any assistance that you can offer would be greatly appreciated. Thanks, have a good day!
|
| HELP - surface plots with missing data (How?) | 11 Mar 2004 14:14 GMT | 3 |
I have a table of data (height ->x, age ->y, weight -> z). The data is placed into a table by a macro as ff: Rows = Height, Columns = Age, and the cell value is the average of all samples having the same age and height. However, some of these cells are
|
| Code to reformat pivot chart | 11 Mar 2004 13:35 GMT | 2 |
Custom formating is lost in a pivot chart when the pivot table is refreshed. I can record a macro to reformat each data series to medium weight but I think it must be possible to create a For...Each...Next loop instead.
|
| Negative #'s on the wrong side | 11 Mar 2004 13:32 GMT | 7 |
Win XP, Office XP I've created a horizontal bar graph starting with negative 30 (-30) up to positive 30 (30). My problem is that while all almost all the negative data labels are on
|
| Text To Columns - Date Conversion | 11 Mar 2004 06:06 GMT | 2 |
Problem: "Text To Columns" converts some dates correctly then skips three years (From 2001 to 2003). In a blank worksheet, I'm bringing in a text page from a Federal Reserve Bank site using a macro I created from Data/Get External Data/NEw Web Query.
|
| Control Bar | 11 Mar 2004 03:17 GMT | 1 |
In Excel, I am trying to put a bar above letters to designate the different types of control charts but I cannot figure this out. I am sure it is something simple but it has me stumped. Thanks for your help.
|
| Pivot Charting Grand Total as Series | 11 Mar 2004 02:35 GMT | 1 |
How can I get excel to chart the 'Grand Total' of the Row as a series on the same chart of the data series? Thanks in advance.
|
| Text boxes within line charts | 10 Mar 2004 22:05 GMT | 1 |
I want to add comments to a chart and have them become part of the Excel chart. I think it is possible, but I don't know how to do it. For example, I want to add a comment describing a trend in
|
| Change Plot Area Default Settings | 10 Mar 2004 22:02 GMT | 1 |
I am always changing the grey background in the plot area to a little yellow every time I create a chart. How would I go into the visual basic template or something to change the settings? Is it hard for a amateur VB programmer? Is
|
| fixing breaks in line-graph | 10 Mar 2004 21:58 GMT | 1 |
I have a line graph with different series. One series has missing data, but I still want a line to connect the dots. Is there any way to fix this problem? An add-in or option I forgot to check?
|
| normal distribution curve | 10 Mar 2004 19:42 GMT | 1 |
how do you create a normal distribution curve in excel?
|
| Narrow column widths | 10 Mar 2004 18:17 GMT | 1 |
I have a chart which if I use column b which is the week number as the axis value the column widths are fine, but if i change the x axis valu to column a which contains the week end date the widths of the colum are reduced to a lin
|
| Dumb charting question | 10 Mar 2004 18:06 GMT | 3 |
I cannot seem to get the charting function to present a simple graph of Y as a function of X. I'm charting spring force as a function of compressed length. X compression results in Y force. Excel seems to want to make both X
|
| circular charting | 10 Mar 2004 17:17 GMT | 1 |
I would like to create a chart that plots azimuth against elevation. This would be similar to a radar chart but with an axis for azimuth and one for elevation. Is this possible?
|