| Thread | Last Post | Replies |
|
| excel chart x/y variable problem | 05 Aug 2004 01:37 GMT | 1 |
I am trying to plot variables on my x and y axis and have the field b standard... such as site = 1 2 3 4 5 value 1 = 10 1 6 8 3
|
| pivot tables | 04 Aug 2004 21:44 GMT | 1 |
I am trying to change the order in how the tables display. I don't want an accending or decending alpha order as it is set up now. I would like to pick and choose how I want them listed.
|
| XY Scatter and a big amount of points | 04 Aug 2004 13:59 GMT | 2 |
In my system XY Scatter there are a big amount of points , when I decide , I put a new value (x,y), two questions: what or how do you do this and Can I have a clean view of the result ? ( the points are very close ). Thanks,
|
| show last data point in chart | 04 Aug 2004 13:02 GMT | 5 |
I am charting a range of observations/data points. Is there a way to make the last data point show up differently on the chart (different color/shape)? Thank you.
|
| Dynamically Hiding Empty Series with VBA? | 04 Aug 2004 12:53 GMT | 1 |
My application generates a chart using VBA that defines the various column ranges and uses Union to sum them for .SetSourceData Sometimes a aparticular series has no valid data - but always has a header.
|
| GROWTH function falls over.. | 04 Aug 2004 10:04 GMT | 3 |
I am using the GROWTH function to calculate the y-axis intercept (i.e. value of y at x = 0) for an exponential function where I have four (x,y) values. This works fine, but if the user goes back and deletes one of the input data points (say if they decide it is a rogue point ...or ...
|
| Adjusting gridlines on the x-axis | 04 Aug 2004 02:48 GMT | 1 |
i have a graph that runs from 1 to 32 on the x-axis and 0 to 3 on the y-axis. i want to adjust the gridlines on both axes to 1x1 and .5x.5 and .25x.25. adjusting the y- axis gridlines is easy, i just double click on the y-axis
|
| selecting range for charting | 04 Aug 2004 02:47 GMT | 1 |
Hi, I would like to write VBA code so that a user can select a subset of a large dataset (via a userform) and have the VBA code create the chart using the subset of data. I have the
|
| Fitting chart border to chart diagram | 04 Aug 2004 02:41 GMT | 3 |
I can't figure out how to resize the chart border without resizing the diagram. I found out within the "Help" part of the program, but when I do what it says, none of the options to click on (Organization chart toolbar: Layout--Fit Diagram to Contents) are active. I have tried ...
|
| Problem with the display of a 2 axis chart | 04 Aug 2004 02:39 GMT | 1 |
I am trying to create a chart with 3 series, where 1 of the series is on the second axis. The first series on the primary axis is a "full" series which are from startdate to enddate. The second series on the primary axis is a series which starts "later" than the first series. The ...
|
| #REF! | 03 Aug 2004 22:27 GMT | 6 |
Two worksheets sheet are used to feed a chart on a third sheet. One accepts the results of a query that's triggered by a macro from a button on an outline (a forth sheet). The second sheet is a worksheet that simply takes data from the query sheet and permits it to be manipulated. ...
|
| Plotting X axis as the log in a semilog plot | 03 Aug 2004 19:06 GMT | 1 |
I can plot a semilog plot that uses the y axis as the log scale. How do I set the x axis as the log scale instead?
|
| Color for chart series auto-assigned after 56? | 03 Aug 2004 04:57 GMT | 10 |
Using Excel 2000, I am having a color issue with charts that exceed 5 series. Below is some sample VBA to reproduce the issue. The cod creates a bar chart with 60 series. The RGB color I have chosen i white (255, 255, 255). You will notice that beginning with series 57
|
| Switch axes | 02 Aug 2004 21:18 GMT | 1 |
I want the data currently on the x-axis to be on the y- axis and vice versa. How do I accomplish this? Thanks, Peri
|
| Pie Chart not to display 0 Values | 02 Aug 2004 17:47 GMT | 2 |
Good day, I have an excel Table something like below. Column A Column B Item 1 24%
|