| Thread | Last Post | Replies |
|
| Add names to scatter plot chart | 29 Sep 2005 18:52 GMT | 1 |
I have three columns of info in my excel spreadsheet. column 1 has names, column 2 has numbers and column 3 has numbers. I can create the scatter plot chart just fine, but what I am having a problem with is that I cannot get the names from column one to show
|
| How to plot a formula with two variables | 29 Sep 2005 18:13 GMT | 2 |
I would like to plot a formula in this form x + y = 0 I know u may say "rearrange it to y = -x" and plot it. This is not what I want.
|
| Add an Average Line in a Scattergram | 29 Sep 2005 18:13 GMT | 1 |
In a scattergram, is there a way to have Excel show a line equal to the average value of the data? I've been including an "extra" point in the data that is equal to the average value and then manually drawing a line through that point after I copy the chart into Word, but I'm ...
|
| Show both value and percentage on Waterfall Chart | 29 Sep 2005 16:57 GMT | 2 |
I need a help on my waterfall chart. I want to show both percentage and value on my waterfall chart and move the value to the top of the bars (and keep on the top of bars) instead of in the middle of the bars. Could anyone show me how to do it? Any help will be deeply ...
|
| Possible to add text from a Cell? | 29 Sep 2005 08:25 GMT | 3 |
I know I can choose a text box to add fixed text in a chart but is there a way to add text from a cell that can vary directly from the workbook (e.g. from cell A1)?
|
| normal distribution curve | 29 Sep 2005 03:34 GMT | 1 |
I'd like to plot a normal distribution but also show where a particular case is on the normal distribution curve. For example, I want to see the curve based on all of the data, then a specific entry to show how close it is in the standard deviation.
|
| Series order in a chart legend. | 28 Sep 2005 20:10 GMT | 3 |
I want to reorder the series in a chart. The posting talk about editing a command line. But I do not see a command line and Excel help does not know what a command line is. When I double clik on the series (as suggested in the postings), the menu does not offer a tab for ...
|
| Adding a certain text label in a excel chart | 28 Sep 2005 20:03 GMT | 2 |
I am plotting in regularly basis a certain set of data in excel. Based on some data analysis this set of data has to be fitted to these equations: y = 1/x^a (1) and /or
|
| Print TextBox | 28 Sep 2005 19:57 GMT | 1 |
I have TextBoxes on a graph, but they do not print. In FormatAutoShape > Properties, Print object is checked, but it will not print. Any help on how to get them to print will be appreciated. Regards
|
| In a 2 Y-Axis chart, how do I assign data ranges to an axis? | 28 Sep 2005 19:52 GMT | 1 |
I have created a 2 Y-Axis chart with 12 data ranges. Numerically, the first 8 data ranges belong on the 1st Y Axis, and the last 4 data ranges belong on the 2nd Y Axis, but MS is choosing to put the first six on the left Y Axis and the last six on the right Y Axis.
|
| show aggregate total in pie chart | 28 Sep 2005 07:32 GMT | 1 |
How do I get a pie chart to show the total value of the pie somewhere on the chart?
|
| Define a chart using VBA | 27 Sep 2005 22:57 GMT | 1 |
I'm baffled- I'm writing a macro to pull a data table into an excel sheet & create a bargraph of those results. The number of records in the data table are variable (say between 2 and 50). I'm trying to define a dynamic bar graph using VBA. The X values are
|
| How to specify values for X axis in a Graph | 27 Sep 2005 17:06 GMT | 1 |
i have two columns of data 1st for X axis & 2nd for Y axis.When i plot a graph selecting both columns,two different series are drawn,with default X axis values being taken automatically.How can I specify to have one columnn to have X axis values & draw graph of the
|
| Is there a way to graph mathematical functions in Excel? | 27 Sep 2005 15:08 GMT | 2 |
I want to be able to graph a mathematical function in Excel. For example put in a table of X,Y variables and output a line graph.
|
| get edit mode on data lines in chart wizard | 27 Sep 2005 15:03 GMT | 1 |
Using the chart wizard, hitting icon NEXT, picking tab page SERIES, I am trying to edit the Values: line of data. I can get into the edit mode by left click'ing the line. What I can not do is move around the line like in a word prosser. When I use the right and left arrows to ...
|