| Thread | Last Post | Replies |
|
| finding angle of slope... | 21 Jun 2006 23:23 GMT | 2 |
Using Chart, Add Trendline, then selecting Linear in Excel to chart a linear regression line on a series creates a new line on my chart with either a positively or negatively sloped regression line. Is there any way, using this built-in Excel feature, to convert the result
|
| Chart Every Other Column | 21 Jun 2006 22:57 GMT | 2 |
How can I chart every other column in a line chart. I was charting by manually selecting each value, but aparently this list got too big.
 Signature MABeatty
|
| How do I change a Chart's axis scale from visual basic? | 21 Jun 2006 20:42 GMT | 2 |
How do I change a Chart's (that is on a worksheet) x-axis scale from visual basic? The following only works when the chart has its own sheet/tab. With Charts("Chart1").Axes(xlCategory)
|
| Chart Lines | 21 Jun 2006 19:01 GMT | 2 |
I set up my chart and it added vertical lines to my data. I removed the lines but it also removed the horizontal line at the bottom of my chart. This is not appealing to the eye. Is there some way to add back the horizontal line at the "0" (bottom) of my chart but I DO NOT ...
|
| Upper Control Limits | 21 Jun 2006 16:31 GMT | 2 |
I have a line chart that shows 12 months of data and a trend line. I computed the Upper & Lower Control Limits using the Standard Deviation. Is there a way to put these lines on my charts so that when my boss looks at it she can tell if one or more of the points are out of ...
|
| Excel Charts - Text Box Problem | 21 Jun 2006 16:14 GMT | 1 |
I have several Excel charts that I am working on for a presentation. I plan on using Powerpoint for the presentation but am creating the charts in Excel. One problem that I am having is that I have a text box that I have
|
| xy-chart | 21 Jun 2006 09:29 GMT | 2 |
I have kind of xy-chart. Values on x and y varies a lot according to calculations so i would like to fit them to my chart area. But i would like to fit them so that x equals y, so the scale is 1:1.
|
| Coloured horizontal stripes | 21 Jun 2006 01:00 GMT | 2 |
Using MS Excel 2003, I want to create a chart that has coloured horizontal bands as a background with the data lines on top of these bands. E.g. If all of my y-axis values will be in the range 0-30, I'd like to
|
| text label in x-axis (scatter chart) | 20 Jun 2006 22:48 GMT | 2 |
I'd like to create a scatter chart but force all the data points into one column for each series (as poorly illustrated below if viewed using fixed font). x x
|
| Can't see 2 open workbooks listed in the Window tab | 20 Jun 2006 22:06 GMT | 1 |
Using Excel 2003 When I have two workbooks open I think I should see both of the workbooks listed in the Window tab on the Menu Bar. I only see the workbook file I am in. What can I do to correct this?
|
| How do I prevent a series line from going to 0 after last value? | 20 Jun 2006 21:51 GMT | 2 |
I have a series of monthly data with values for Jan - Jun, but blank values for Jul - Dec. It's a 100% stacked column chart with the series lines added in. Currently, the series lines all drop to 0 in July. I need them to end at Jun (or last month with non-blank data), but ...
|
| Chart Coloring | 20 Jun 2006 21:45 GMT | 1 |
I need a way to select the color for the bars in a bar chart befor the creation of the chart. I know how to select the colors once the chart is created, is there a way to automatically change the chart colors?
|
| Color of a specific gridline | 20 Jun 2006 21:37 GMT | 1 |
Can I change the color of a specific gridline? Or is it not possible?
|
| 2 axis in excel 2007 | 20 Jun 2006 18:43 GMT | 1 |
I have installed Office 2007 and unable to make graphs with 2 axis (one on the left and the other on the right) in excel. Excel 2003 had such graphs templates available. How do I create 2 axis charts in excel 2007. Any suggestions.
|
| Creating a graph based on a chosen group of data | 20 Jun 2006 14:46 GMT | 1 |
I have a list of data that contains multiple groups I am trying to create a graph that will show only the group that the user selects from a dropdown box. The data looks like this: Group Item Data
|