| Thread | Last Post | Replies |
|
| Graphs (equation of a line) | 14 May 2008 12:04 GMT | 1 |
what does (y= 5E +0.6x) mean in an equation of a line? I need to include this on my conclusion for an experiment.
|
| Retrieving linked label formula with VBA | 14 May 2008 09:54 GMT | 1 |
Dear group, I linked datalabels of a chart with cells (by selecting a single label, typing "=", clicking the cell to link with and then enter). Now I want to get the label's formula with VBA, but I only get the value
|
| Graph Fill Pattern Question | 14 May 2008 08:56 GMT | 2 |
In Excel 2007, how do I do a simple fill pattern in the graph? I have a graph and I can get the bars to be filled with solid colors. I can even get preselected, really fancy patterns. However, I CANNOT get it to be filled with a simple pattern like with black dots or with ...
|
| How do I change chart format default settings to my preference? | 14 May 2008 08:55 GMT | 1 |
I am using Excel to make charts and would like the background to always be white instead of grey? The same applies in order to change the column colour defaults away from red and purple to personal choices.
|
| Contour Maps form Excel Charts | 14 May 2008 07:56 GMT | 2 |
I thought that it would be simple but apparently not. I am trying to create a contour map from XYZ data points. I am using Excel 2003. I tried the surface plot examples but can't seem to make sence of it. Can someone give me a little help? Here is a small set of the data I'm ...
|
| Creating data from a chart | 14 May 2008 03:52 GMT | 3 |
If someone emails me a chart, but does not include the source data, is there anyway to generate that data from the chart?
|
| How can I add a new axis as a line chart toa stacked bar chart | 13 May 2008 19:26 GMT | 1 |
I have 5 months of data as a stacked bart chart - the Y-axis is the count of orders that missed target due to a particular reason. So for month 1, there are 100 misses across 5 categories; in month 2, there are 80 misses across the same 5 categories etc. I want to add a new ...
|
| excel dynamic charts samples | 13 May 2008 19:24 GMT | 4 |
Please send me excel dynamic charts samples. Thanks.
|
| Percent of increase each year | 13 May 2008 18:21 GMT | 2 |
hello, I want to create a bar or line chart that shows the percent of increase in our sales but no values. We want to give a corporate overview, on average each year we've been producing 15, 16, 17% more GP annually. I want to show this growth without showing the amount of money ...
|
| Switching X and Y axis | 13 May 2008 17:56 GMT | 3 |
How do I switch the data on the X and Y axis? For instance, I am trying to do a supply and demand chart, and I want Price to be on the Y axis. No matter how I plot the data, Excel always defaults to the supply and demand figures on the Y axis.
|
| Can you make a series 2 bar the same in the chart? | 13 May 2008 17:31 GMT | 1 |
My manager has a spreadsheet that he wants to make into a bar or column chart. I have done all of that and set it up. My problem is he wants the second bar to be the same all the way across for each month. How do I make each bar the same all the way across for each month? Do ...
|
| Graphs from Excel into Adobe Illustrator | 13 May 2008 12:23 GMT | 1 |
When I copy a a 3-d pie chart from Excel into Illustrator it has jagged edges. How can I fix this? I used to copy as picture in the previous version of Excel and this worked fine, I am now using the latest version of Excel.
|
| Horizontally Banded Chart Background. - on Stock charts | 13 May 2008 05:38 GMT | 3 |
I have 3 series of data, Hi/Lo/Avg that I am plotting using a Stock type chart with 3 data points. I want to use a Horizontally Banded Background to indicate the desired range.
|
| Comment balloon on a chart | 13 May 2008 04:11 GMT | 1 |
I have a chart that I want to put a "Comment Balloon" on. Is there a way to do this?
|
| Don't plot non-numeric cells | 13 May 2008 01:04 GMT | 2 |
Tools - Options - Chart - Plot empty cells as: Not plotted (leave gaps) works only when the cell is actually empty. The cell is empty when raw data is missing, but the raw data has to be subtracted from a constant value. I'm using =IF(ISNUMBER(B4), B$1-B4,NA()) which returns ...
|