| Thread | Last Post | Replies |
|
| How can I display my table in chart area? | 27 Apr 2007 12:15 GMT | 1 |
I have a table and I create a line diagram from this table. I want the table (data) to be shown in chart area. How can I do that? Regards
|
| How do I use the templates for job cost tracking? | 27 Apr 2007 07:00 GMT | 1 |
I work for a design/built firm. We provide customers with a typed (Excel) job estimate. We then use this estimate in-house to maintain cost versus estimate. We need a template(?) so we can pull some of the information out for simple reporting purposes.
|
| Two alternative scales on same chart?? | 27 Apr 2007 01:26 GMT | 1 |
Is it possible to do two alternative scales on the same chart? If so how is it done? Thank you in advance for your assistance.
|
| Excel 2007 - Can I add to a Line of Best Fit | 26 Apr 2007 14:38 GMT | 2 |
I've got a scattergraph and developed a line of best fit. (For info, it's a 4 order polynomial.) What I'd like to do is show additional lines on the chart +/- 20% around the calculated lobf - basically so I can see what points are outside that range.
|
| Bars and Area at the same time | 26 Apr 2007 13:39 GMT | 2 |
I'm currently using Excel 2000 but upgrading to a new version isn't a problem if it will solve my issue. I have six sets of data that I need to put on a single graph. I'd like to have three of the sets as stacking bars and the other three as Area in the background. Is this ...
|
| Excel 2007 - Adding Labels to Scattergraph Points | 25 Apr 2007 16:46 GMT | 2 |
I've got three pieces of data for each person on the payroll - each in a column - salary - length of service
|
| Show Percent changes | 25 Apr 2007 15:50 GMT | 1 |
I'm doing a simple bar chart, and I'd like to somehow display the change in terms of a percentage for each series. This is probably an easy feature, but I can't figure it out. Thanks.
|
| I would like to add a base line to a chart ... | 25 Apr 2007 11:42 GMT | 2 |
I have a chart which tracks workhours per week. Across the bottom are the dates representing the ends of the weeks (1/7/07 through 12/30/07), and along the left are possible hours per week (0 through 70). I am using a line chart with markers.
|
| How to change transparency of series | 25 Apr 2007 10:19 GMT | 1 |
Do you know how to use the transparency button in Format data series->Patterns->Fill Effects->Gradient? I found the button in it is grey.
|
| trendline equation does not display correctly | 25 Apr 2007 06:50 GMT | 1 |
I am using Excel 2007. When I change the order of the trendline from 2 to 3, the cubic term does not appear. If I rasie the order to 4 there is still no cubic term. Only when I raise the order to 5 does the cubic term appear. I suspect that the higher order terms are not ...
|
| Syntax for selecting a textbox within a chart? | 25 Apr 2007 02:39 GMT | 4 |
I am writing a macro that will insert text & a cell value into a similarly named text box within multiple charts, but being a noob with VBA, I'm not sure of the syntax to use to select the text box in question. I was starting with a simple bit of code that did the same thing for ...
|
| x-axis time series with 2 different begin dates | 25 Apr 2007 02:39 GMT | 5 |
I want to show 2 time series in 1 chart with different start dates. Series 1 begins 1996 and run through 2006. Series 2 starts 2000 and also stops on the same end-date 2006. Both use the same $ scale on the y-axis. Excel puts them both as having start-year of 1996 with the ...
|
| Using a Named Range for Data Source In A Chart | 25 Apr 2007 02:33 GMT | 2 |
I am trying to create a chart that picks up the last 12 months of data I have created a named range called Test. Test refers to =OFFSET(Sheet1!$B$1,1,Sheet1!$C$1,2,12) When Sheet1!C1 changes the range location changes.
|
| making boxplot in excel 2007 | 25 Apr 2007 02:29 GMT | 2 |
Hey. Got a problem on making a boxplot in excel 2007. I used to make excel 2003 to make the boxplot, but now I have the 2007 edition. I learned from my teacher that I need to use the "High-Low-lines" and the
|
| Graph Area is Covered by Grey Shading | 25 Apr 2007 01:24 GMT | 2 |
I have a graphic display problem. I'm not sure if I accidentally did something to change my settings or not, but the problem is all graphs that I am creating have a gray shading over them which completely blocks out all graphic info. If I click on one of the graph areas, it ...
|