| Thread | Last Post | Replies |
|
| Excel 2007 Chart creation | 30 May 2009 14:43 GMT | 1 |
When I use the Ctrl key to select more than one range, not all of the ranges "selected" are selected. It only selects one X axis range and one Y axis range from several selected ranges. Do I need to activate something somewhere to make it work right?
|
| 2709 point limit in Excel 2007 scatter plot | 30 May 2009 14:36 GMT | 3 |
It appears that I cannot print a line-only scatter plot with more than 2709 points in the series. In a new workbook, I filled column A with "=row()" and column B with "=sin(0.01*a1)". The chart appears correctly on the screen and in the print
|
| Line Graphs | 29 May 2009 22:41 GMT | 4 |
Is there a way to shade the area between two lines in a line graph, while leaving the rest unshaded?
|
| different y-axis auto scaling... | 29 May 2009 22:39 GMT | 3 |
prior to excel 2007, i recall a setting for the y-axis, something like "Major Unit" and "Minor Unit" - i could set my y-axis to be 0,5,10,15,20.... or 0,10,20...depending on the Major or Minor unit values. is that ability still in excel 2007??
|
| y-axis auto scaling... | 29 May 2009 22:36 GMT | 2 |
every chart i create has a y-axis starting at 0, even if my data is something like 100,101,105,99 (all close to ~100). ideally, the chart's y-axis ~should be something like 90 - 110, or something like that. is that just how excel (2007) works?? i know i can manully change max and ...
|
| Making a graph with easily changed dates | 29 May 2009 22:23 GMT | 3 |
My boss asked me to make a graph on one of his spreadsheets more user friendly...so that you could put a start and end date in two ajacent cells and the graph will automatically change to show the time between those dates. I didn't think it was going to be too hard but now i'm ...
|
| minor and major gridlines | 29 May 2009 22:21 GMT | 4 |
i want to have 5 minor gridlines in between each pair of major gridlines on the value axis. how can i do that?
|
| i need to setup an office work schedule grid for 7 employees | 29 May 2009 21:35 GMT | 1 |
How do I setup a Timeline Grid for an of 7 people?
|
| Excel 2007 Chart creation | 29 May 2009 17:00 GMT | 1 |
When I select 2 or more non-contiguos ranges to create a chart, it's not selecting all the ranges I select. It only selects one cell in one range and onther cell in another range. Does the Crtl key need to be activated somehow? If so, Where?
|
| Excel: How automatically read coefficients from polynomial fit? | 28 May 2009 20:37 GMT | 1 |
I need the coefficients from a polynomial trendline in a chart for further calculations in excel. Is there a function in excel to get it automatically or do I need to manually type the values displayed in the chart into my worksheet?
|
| How do i plot two series of data both in accending order on a line | 28 May 2009 09:14 GMT | 1 |
I have multiple series of data to plot in a line graph that I want view from the lowest to highest. For example: sales sold by REP AND product type & person. Each series represent a type of product. the Vert scale is the number sold and the horz scale is the rep
|
| 3D histogram? | 27 May 2009 19:09 GMT | 2 |
I need to create a 3D table from a multitude of data points, similar to the 2D histogram but in 3D. The data is engine data gathered from road testing of a vehicle in the form of throttle position (TP), engine speed (RPM) and engine load. Engine load is the value that I'm ...
|
| Drawing points on a three colored chart region | 27 May 2009 14:42 GMT | 1 |
I need to create a chart that shows a group of points, like: Axis x goes from 0.0% to 100% Axis y goes from 0.0% to 500% Point 1: x=5% y=30%
|
| Dynamic charts in 2007 | 27 May 2009 14:04 GMT | 2 |
I've used dynamic charts in 2003 for several years. I now have an internal customer who has moved to 2007 and would like some dynamic charts. I obtained access to a 2007 machine, loaded his current workbook, and noted that the interface is very different.
|
| Data Labels - I Only Want One | 27 May 2009 09:26 GMT | 1 |
Using X-Y Scatter Plot charts in Excel 2007, I am having trouble getting just one data label to appear for a data series. After selecting just one data point, I right click and select Add Data Label. I am then provided with the Y-value, though I am looking to display the ...
|