| Thread | Last Post | Replies |
|
| Resizing trendline title in legend | 18 May 2007 00:11 GMT | 2 |
Im having trouble resizing the legend from 3 lines to 1. I have used a scatter chart and then Add Trendline>Moving average. The legend that is auto-generated is "10 per. Mov. Avg. (PROJECTED
|
| Chart size | 17 May 2007 17:15 GMT | 1 |
I am having many charts in many sheets in a workbook I want to have the same size of the chart I am plotting in the sheet not in a seperate window Any help
|
| graphs | 17 May 2007 15:16 GMT | 1 |
how do you add quadrant lines to a graph?
|
| Avoid plotting refferanced blanks as zeros in scatter plot graphs | 17 May 2007 15:15 GMT | 17 |
I can not figure out how not to plot data that referances blank cells as zero's. I have a worksheet that links to tables with data orginized by size (mm) from big to small. This worksheet contains a scatter plot graph that looks at all sizes in the table. Typically not all ...
|
| Plot area distorted when I copy Excel chart into Powerpoint | 17 May 2007 12:56 GMT | 1 |
I am trying to embed an Excel chart into a Powerpoint slide. The chart is an object located on an Excel worksheet and is sized (5.45" x 9.3") such that no scaling is required in Powerpoint. I have the "lock aspect ratio" option turned on.
|
| drawing bell graphs side-by-side | 16 May 2007 19:55 GMT | 7 |
i'm trying to draw two normal distribution bell graphs side by side in a same drawing. i was able to draw two different bell graphs following the help provided earlier, but still cannot draw them together with some overlapping tails.
|
| How do I change the default line colors in Excel graphs? | 16 May 2007 18:39 GMT | 2 |
I would like to use a color scheme that is viewable. Presently the first color selected by the program is light blue. How do I set the default colors to my choice? Can I set several color schemes for different end uses like printing versus projecting?
|
| Side-by-side bar chart | 16 May 2007 16:35 GMT | 2 |
I'm using Excel 2007. The goal: I want to build a bar chart that has two bars for each value (one is volume, the other is effectiveness). Category Effectiveness Volume
|
| Bar Chart | 16 May 2007 04:57 GMT | 1 |
I would like to do a column chart that groups the bars representing the data points adjacently, for example: 3/2006 sales and 3/2007 sales / 4/2006 sales and 4/2007 sales, etc. Any ideas?
|
| Color vs Colorindex for series border | 16 May 2007 02:37 GMT | 1 |
Running on Excel 2003, I am attempting to set the .border.color property for an x-y scatter series object using a long value that was generated by the RGB function. However, the colorindex property seems to override it. I can successfully change the marker colors, but the .border ...
|
| Dynamic Charts Problem | 16 May 2007 01:59 GMT | 13 |
I did some googling this weekend and found lots of helpful advice on how to make dynamic charts with named ranges and OFFSET, INDEX, and MATCH functions. Anyway, I was able to successfully create the dynamic charts that I wanted by pointing the series data at a named range. For ...
|
| How to group bars showing counts and overlay line compliance chart | 15 May 2007 22:17 GMT | 4 |
Using data similar to what's below (month, ticket count type, customer, SLA compliance %), I'd like to be able to have the bars with the # of tickets opened and closed for each month grouped so the bars touch each other while still having space inbetween each months' bars (using ...
|
| Slope line in stacked area chart | 15 May 2007 20:12 GMT | 3 |
How can I change the slope between two points in a stacked area chart to be a vertical line? My x axis is years, and where my data goes from 0 in year 1 to 100 in year 2, I get a slope upward --- but I don't want that; I want to see a vertical line as the beginning of the area, ...
|
| Maintain formatting in linked chart title | 15 May 2007 19:07 GMT | 1 |
I am linking an Excel chart title to a named range. Is there any way to maintain the formatting used in the named range in the chart title?
|
| calculate the area under the curve | 15 May 2007 17:53 GMT | 2 |
How can i calculate the area under the curve?
|