| Thread | Last Post | Replies |
|
| Pls HLP - Label Above Column in Stacked Chart | 25 Jul 2007 12:54 GMT | 3 |
I am working with stacked "floating" charts and have almost succeeded in doing what I want... However, I would like both the value of the column, plus the % of the total, to appear ABOVE the columns.
|
| How Make Y Axis Start at Other than Zero? | 24 Jul 2007 21:59 GMT | 1 |
I have a Y axis from 0 to 300. I'd like it to be from 180 to 275. How can I do that or at least get closer to the optimal axis numbering? 180 to 300 or 175 to 300 would be OK. My data points are currently between 273.4 and 267.8. Thanks.
|
| Resizing chart labels | 24 Jul 2007 19:40 GMT | 3 |
Hi I was just wondering if there was a way to resize the labels on charts in Excel 2007? I can click onto the label, but it doesn't allow me to change the size. The only way i can fit words onto a single line is by selecting a smaller font. Is there another way?
|
| data labels | 24 Jul 2007 15:32 GMT | 4 |
i have a spreadsheet that contains a bar graph based on 2 columns. basically the graph compares goals to actuals. the challenge here lies in the desire to add in the the data labels, which are based on the 4th column of data. right now, i have text boxes showing these ...
|
| Remove Links | 24 Jul 2007 14:42 GMT | 1 |
I'm in Excel 2000 Is it possible to remove the links from a chart? I have a workbook with several charts on the first sheet. Those charts are based on data located in other sheets of that workbook. I want to copy the
|
| Charts: Can the Default settings be changed | 24 Jul 2007 14:37 GMT | 1 |
The defalt background is grey and the line colors are awful. How do I change these default settings so that I can avoid having to change each line width, color, point size and shadow. We're can I find the menu to make this change
|
| data range is too complex. | 24 Jul 2007 12:54 GMT | 1 |
I am just changing over to excel 2007. . Most of my data will update to the embedded chart just fine but one tells me "the data range is too complex to be displayed. I don't know how to fix it
|
| Subscripted text in the legend of a graph | 24 Jul 2007 08:58 GMT | 3 |
I have been trying to write a legend in a graph which has some of its part subscripted. However, I have not been able to do so. Could anybody show me a way out. nure
|
| Y axis box size incorrect in Excel 2003 | 24 Jul 2007 08:52 GMT | 1 |
I am having a problem; the y-axis box size does not display the entire text. I cannot change the size of this box. This only happens for the y-axis, not for other axis labels or the chart title. I have tried adding spaces followed by a period to fool the box and this
|
| Making Static Lines in Chart | 24 Jul 2007 08:51 GMT | 1 |
I am generating a chart (Stacked Bar) where number of series is fixed (6) but number of data points vary and as a result the scale of the Y axis keeps on changing every time it is refreshed. I also have three lines on top of the chart which I need to show to
|
| I cannot make charts with two Y axes anymore | 24 Jul 2007 08:48 GMT | 1 |
Now that I have Excel 2007, I cannot find the same template as I had in the previous versions of Excel. I must be missing something. Lines on 2 axes used to be included on the Custom Types menu, but I cannot find it anywhere on the 2007 chart menu.
|
| Create combo chart 2007 | 23 Jul 2007 21:02 GMT | 2 |
I now have Excel 2007 and what used to be easy is not so in many cases. One of these cases is the creation of a combo chart - a set of 3 columns that are represented by bars and 1 column represented by a line with a seperate axis. I know I've done it before, I think they were ...
|
| Pivot Table Drop down | 23 Jul 2007 19:20 GMT | 2 |
I am using pivot charts I created in Excel 2003. When I open the old charts in Excel 2007 they open in the compatibility mode. The drop downs that I had in the chart to look at different data is missing. How do I get the drop downs to show back up. I can alway go back to the ...
|
| Stacked Columns - Order of Stack | 23 Jul 2007 15:28 GMT | 1 |
Using Excel 2003. Have five stacked columns. Want to change order of only one stack; the only one that has more than two values in its stack. Was able to shift order of one of the two stack columns but the one with three values doesn't give me the same screen that permitted me to ...
|
| Is there a macro to create charts automatically? | 23 Jul 2007 09:52 GMT | 5 |
I have a sheet of data that relates to individual performance scores. Each person has their data on one row which goes - Name, Team, Score 1, Target, Score 2, Target, Score 3, Target, Score 4, Target. I need to produce an individual graph for each person containing only the 4
|