| Thread | Last Post | Replies |
|
| Chart updates using cell reference | 21 Nov 2005 20:10 GMT | 2 |
I have a multiple charts that plot data in A1:Z20. Column A is always the x-axis. Columns B-Z represent different charts. Sometimes I want to see all 20 rows of data, but sometimes I want to choose only a few rows (to zoom in) and plot only a few rows...say 8-14. I'd like to ...
|
| Color points on Gantt | 21 Nov 2005 18:57 GMT | 2 |
I have created a pseudo Gannt Chart which is a calendar of when these people are out of the country. The plot excludes the first column of data. Name is on the y axis and the bar starts at Date and continues for 'remaining' days.
|
| Charting Time Samples | 21 Nov 2005 17:27 GMT | 3 |
I have a spread sheet with a time value in hours:minutes:seconds in column A and another on column B with a value in hours:minutes:seconds. In column C is the difference betwen the two. (=TEXT(B1-A1,"h:mm:ss") with a results like this....
|
| Producing line and bar graphs on same axis | 21 Nov 2005 17:20 GMT | 1 |
I have two datasets in Excel 2002 showing glacial recession for a particular glacier in Switzerland. The column headings are the same for both datasets, and are as follows: Timespan, No. of years, Glacier Length Change (m), Cumulative Length Change (m), and Change Rate Per
|
| How do you plot data points on a state map? | 21 Nov 2005 06:56 GMT | 1 |
I have a worksheet with data grouped by city. I want to plot several cities on a map of California - is there any easy way to do this in Excel?
|
| add a day to Source Data Value | 20 Nov 2005 15:20 GMT | 4 |
I am using this Source data in the Value in my chart. ='C:\Documents and Settings\Randy\Desktop\[SCOTTRADE.xls]Symbols'!$F$4:$F$34 Is there a way for it to change every time I update? I want it to get the information form $F$4:$F$35 then the next day add $F$4:$F$36 and the
|
| creating stacked charts with two comparative columns | 20 Nov 2005 15:09 GMT | 4 |
How do you create a stacked chart with two comparative columns, each column containing different data series. Example: column one would have various categories of type of items sold in $, column 2 would have $ shipped, back ordered.
|
| Trendline Equations | 20 Nov 2005 13:22 GMT | 2 |
I need to know how to change the number of digits displayed on the trendline equation. I don't think it is possible but I made an exponenital curve and the equation they gave me is not nearly accurate enough and is certainly not as accurate as the eqaution the program graphed!
|
| Positioning of y-axis scale | 19 Nov 2005 19:01 GMT | 3 |
Hello, All! I hope this is not a FAQ but I have not been able to think of a suitable search phrase. In one particular chart, I find it convenient to have the y-axis on the *right* for quick reference
|
| Make Histogram and Normal distribution. | 19 Nov 2005 18:04 GMT | 2 |
Hi all, I have a problem. I have a set of data (from 108 people, all percentages) which I would like to put into a histogram. I can do this manually but as it is part of an Excel Tool would like to be able to do it automatically. I was
|
| Why doesn't my chart update when underlying data changes? | 19 Nov 2005 17:31 GMT | 3 |
when the source data of my chart changes, the chart does not update accordingly. Is there a refresh button like in pivot tables that I can press to update the chart?
|
| Macro fails in Pie Chart - Can Microsoft / MVP please comment | 19 Nov 2005 12:28 GMT | 2 |
I posted this on 17 Nov 2005. Andy Pope in a reply post has confirmed that he can reproduce the problem. Please can someone at Microsoft or an MVP see below and offer soem advice Microsoft Office Excel 2003 (11.6355.6360) SP1
|
| Format XY data points as pictures | 19 Nov 2005 03:52 GMT | 3 |
Hello, all: Does anyone know a method of replacing XY data point makers with pictures? (in this case, corporate logos) I know how to do it with Bubble chart data points but unfortunately that
|
| Chart Zooming and scrolling | 18 Nov 2005 23:29 GMT | 3 |
Please shoot me or somehow put me out of my misery! Try the following: (1) Create a dummy scatter chartsheet manually. Data is not important, chart can be completely blank for this test.
|
| Category axis in bubble chart | 18 Nov 2005 21:58 GMT | 1 |
I would like to draw a bubble chart with category axis eg. with following data: mon sun 5 mon rain 4
|