| Thread | Last Post | Replies |
|
| How can I auto update a graph? | 30 Nov 2004 19:40 GMT | 2 |
I was wondering if there is a way for me to auto update a chart that I am using.
|
| compare unique identifiers in multiple ranges | 30 Nov 2004 18:35 GMT | 1 |
Excel 2003. I am trying to find a simple subroutine that will allow me to compare entries in multiple, separate ranges, and to produce a new range containing the entries that are common to all of the initial ranges (what I would call an "intersection" set of identifiers). The ...
|
| HOW TO: Plot a Team Name on a chart based on two values | 30 Nov 2004 17:27 GMT | 1 |
I have the following table exmaple, what I like to do is to plot the team as where their values cross, e.g. for TEAM 01 where 5 and 60 cross on a graph having Revenue as the Y axis and Clients as the X axis. COLUMN A COLUMN B COLUMN C
|
| Chart newbie help, please, How to create | 30 Nov 2004 16:18 GMT | 3 |
I want to track my son's racing progress but am not sure how. I have a header row of Date, Racer1 time, Kart used, Racer2 time, Kart used. Each row is a separate race (many times more than one race per day, if it matters) for each driver. How do I crete a chart that will show a ...
|
| Excel Charts and cells | 30 Nov 2004 14:31 GMT | 1 |
Why are empty cells (created via formulas) not represented as ordinary empty cells in a Line Chart - and how can I make that happen?
|
| Trendline error??? | 30 Nov 2004 04:41 GMT | 3 |
Has anybody else had this problem? If one uses a 6 order polynomial as trendline and then s/he enters manually in an other column the same equation taken from the displayed trendline equation on the graph , the original trendline is different from the one manually entered. Excel ...
|
| Format Data Series Markers | 30 Nov 2004 03:38 GMT | 1 |
I have a data series with markers on it. When I included the markers, automatically a large number of them appeared and were overlapping. Is there any way I can change this so there are only a few marker on the series? It tried going through the help menu, but did not have all ...
|
| Is there a way to offset the y-axis of a chart without having the. | 30 Nov 2004 03:35 GMT | 1 |
I'm making a xy scatter graph for my boss. She wants me to offset the y-axis to the right a little, but does not want anything to the left of it. Is there a way to do this in Excel?
|
| One bar, Two colors? | 30 Nov 2004 03:33 GMT | 2 |
I would like to have one bar on my Excel chart use two colors to note goal numbers vs actual numbers. Is it possible to have one bar with two colors while all others maintian one?
|
| Extending a Chart Data Series from an Array - Can it be done? | 30 Nov 2004 03:31 GMT | 8 |
I am trying to create some VBA code that will extend a chart data series from an Array. Google searches on the subject tell me that there is a known bug that will not allow this. The code fails on the last ActiveChart.SeriesCollection line. Any ideas for a workaround? Can I ...
|
| multiple scatter graphes how to plot 3 sets of data for x y on th. | 29 Nov 2004 20:22 GMT | 2 |
I would like to know how to plot multiple sets of data on a scatter graph for example i have 3 sets of data for three types of lighting systems, red, green and blue i want to plot the voltage againt the current, and i want all the data on one graph so i can compare them, how do i ...
|
| Bar Chart for Text Data | 29 Nov 2004 19:04 GMT | 1 |
I am trying to construct a bar chart showing students on the x axis and letter grades on the y axis. The data won't graph unless I make another column assiging a numerical value to the letter grade and plot the number. Any ideas?
|
| How can I hide points for future dates on a Year to Date chart? | 29 Nov 2004 17:23 GMT | 1 |
I don't want future points to show because if there is no data, it either goes to zero, or I can keep the point the same as the previous month. Neither result is good for me.
|
| How can I display multiple series in a pie chart? | 29 Nov 2004 11:22 GMT | 1 |
Here's an example data / chart spreadsheet: http://temp.ancientpc.net/po/piechart.xls Ideally what I want to do is force the pie chart to use the most recent / lowest data series through some way of calculating the lowest non-empty cell
|
| Named dynamic ranges, copied worksheets and graph source data | 28 Nov 2004 17:19 GMT | 9 |
I have a worksheet setup that graphs data contained in two dynamic named ranges. The graph is an object within the worksheet and not a separate graph sheet. The named ranges are defined as follows using the dynamic range name addin for Excel:
|