| Thread | Last Post | Replies |
|
| Can I, and how? | 31 Dec 2005 20:38 GMT | 3 |
I have a chart that's *almost* exactly what I want. However... 1.) value range displayed My values range from 9.5 up to 68 inches. Excel insists on setting the chart to 0 (zero) thru 80. (Currently the zero is technically
|
| Why aren't dates always available to group in pivot tables? | 31 Dec 2005 18:25 GMT | 4 |
I download data that gives me sales number by individual day. I build a pivot table to get total sales by day and then group the process day by month or quarter. Sometimes this works perfectly, while other times I get the message 'Cannot group that selection'. Has this ...
|
| how can I make real polar plots in excel? | 30 Dec 2005 21:48 GMT | 4 |
The radar charts in excel are not true polar coordinate graphs. SuperCalc had a graphing routine that produced charts using polar coordinates, how can I do this in Excel?
|
| charts and cells | 30 Dec 2005 21:16 GMT | 2 |
I have a worksheet with a name in cell A1. There are 18 charts on the worksheet. I'd like to have the chart headings read the name in cell A1 and display that as part of the chart heading on each of the 18 charts.
|
| how do i make an xy graph start at 0 instead of at 1? | 30 Dec 2005 18:48 GMT | 6 |
I made a scatter graph, with the origin value at 0. when i made a line of best fit, the line starts and 1. how do i make it start at 0??
|
| Line - Column Charts | 30 Dec 2005 17:49 GMT | 1 |
I am using line-column charts to show productivity metrics. The columns (bars) are indicators and the line as a benchmark. After 5 indicators, the bars change to data poitns. Is there a way to have multiple bars (columns)?
|
| Data Labels | 30 Dec 2005 15:57 GMT | 5 |
Excel 2000: The data labels are showing with a white background on a gray plot area. I have formatted the data label background to the same colour of gray but it remains white when I print the chart. I'm obviously doing something wrong. Any suggesions? Connie
|
| How do I put multiple pie charts on one page? | 30 Dec 2005 15:48 GMT | 1 |
I am trying to make a page that has multiple pie charts on it how do I get them all on one page and make it look nice?
|
| Excel 2003 won't let me change Xlabels from scientific notation | 30 Dec 2005 14:22 GMT | 1 |
For some reason, when I type in bin bounderies for a histogram as: 0.0000 , 0.025, 0.050...... 0.175, 0.200 excel keeps changing them to exponential/scientific format, which not only takes up a lot of space, but just looks dumb. How can I force excel to show the labels the way I
|
| moving a pivot table graph and keeping the formatting | 30 Dec 2005 08:32 GMT | 1 |
When you move a pivot table graph to a new workbook the formatting will change. How can I keep the exact formating of the graph?
|
| Bubble chart challenge | 30 Dec 2005 08:23 GMT | 1 |
I am trying to create a bubble chart or scatter graph that is divided into 4 quadrants with each quandrant using a different set of benchmark data (ie Large growth , Large Value, Small Growth, and Small Value). I then want to compare my "portfolio" over time to these benchmarks ...
|
| Scattergraph | 29 Dec 2005 19:06 GMT | 5 |
I have tried to enter some simple data, consisiting of height and weight variables onto a scattergraph and have formatted the cells as "numbers": Height Weight 1.56 53.00
|
| How do I offer ChartType options? | 29 Dec 2005 14:13 GMT | 4 |
I have a chart loaded onto a Userform and am looking for a way to fi multiple chart options via option buttons. To illustrate, catering fo 2 options, I attempted something like the codes below which failed wit Type mismatch error. (The variable CharttNme is declared global a
|
| Hard-code source data | 29 Dec 2005 14:07 GMT | 5 |
Is there any method other than using Dynamic Names/OFFSET to force a chart to always use specific columns and rows, regardless of whether or not new ones are added. We have multiple spreadsheets that track monthly metrics. Each month a new
|
| X Axis:Change Numbers on Chart ? Please Help! | 29 Dec 2005 14:01 GMT | 2 |
Hello - I'm working on a project and using an Excel Chart for the first time. I need the numbers on the X axis to reflect specific numbers (1.1, 1.2, 1.3, 1.4, 1.5, 2.1, 2.2, 2.3, 2.4, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, etc.) for a total
|