| Thread | Last Post | Replies |
|
| data missing in charts original file 97-2003 opened 2007 and then. | 10 Feb 2007 17:36 GMT | 1 |
I have a file that is created in 97-2003, after it is opened in excel 2007 and then saved back to 97-2003 version when it is reopened the charts that are included are not showing any of the text data or information that was added to the charts. Anyone else have this problem or ...
|
| Creating Multiple Excel Charts | 10 Feb 2007 16:57 GMT | 1 |
Is there any easy way to create charts in excel? I have 24 graphs (on one page) to create and show actual and budget data on a line graph, the actual and budget data are on separate tabs. It is for a rolling 24 months time frame, and I have to have similar graphs for four
|
| Leader Lines in charts other than pies? | 10 Feb 2007 16:16 GMT | 1 |
Is it possible to automatically create leader lines from label to data plot in chart types other than pies? When I drag my labels away from the data in a line chart, there's no leader. I'm trying to avoid doing this as a paint job. TIA.
|
| Changing gap depths | 09 Feb 2007 20:32 GMT | 2 |
I made a 3-D bar chart yesterday for the first time. My boss wanted something a wee bit different than what I gave him (but he was happy with the results). I had a chart that was 4 columns deep, 14 columns wide. Is there a way to change the gap depth so that the first two and ...
|
| Comparing Data | 09 Feb 2007 14:41 GMT | 7 |
I would 1st like to say thank you for anyone who reads this as what I am currently doing is taking way to long and I'm sure there is a better way of speeding this up. This is what I'm trying to do. I have a workbook that contains 2 worksheets
|
| How can I combine a 3-D column and stacked column chart | 09 Feb 2007 11:40 GMT | 2 |
Imagine that your income comes from two streams. To make clearer the year-on-year differecnes you like to display a 3D chart by year by month, but use a stacked column to show the two income streams: X = month
|
| How do I display cell comments in an excel graph? | 09 Feb 2007 08:23 GMT | 4 |
There are comments in the data that I wish to have displayed in the chart.
|
| Dynamic Charting But for a Stacked Colum Chart | 09 Feb 2007 01:34 GMT | 3 |
Hi Excel charting Gurus, I have been trying for 3 days to adapt the dynamic Charting examples from Jon Peltier's and TechTrax (http://pubs.logicalexpressions.com/ Pub0009/LPMArticle.asp?ID=246)
|
| x axis tick marks | 08 Feb 2007 23:27 GMT | 3 |
How do I add tick marks on the x axis for irregular time periods. Each period may have only 5 points of data or 12 points. The name of each period needs to be between the tick marks to indicate the exact time period.
|
| Charting zeros as non zeros | 08 Feb 2007 22:18 GMT | 3 |
I have data I would like to chart in a line graph. Is there a way to display a line graph and prevent the line dipping to zero for zeros? I've tried to no avail to reference or convert zeros as a blank cell as the chart will not consider the blank as a point on the graph line. ...
|
| Incorporating 2 different worksheets | 08 Feb 2007 18:08 GMT | 6 |
Could I get help in incorporating data from 2 different worksheets into one graph. Does anyone know if this is even possible. I've tried holding CTRL and selecting another worksheet but Excel won't let me. Is there a manual way to type in the cell ranges? Thanks
|
| vertical gridlines in 007 | 08 Feb 2007 18:01 GMT | 3 |
Has anyone tried to format a vertical gridline in 007? Everytime I try it, the horizontal gridlines are formatted instead. And I can't select the veretical lines with the mouse (I have to use the layout format selection).
|
| Adding a second series to an existing chart | 08 Feb 2007 17:46 GMT | 4 |
I have a very simple question, I would like to add a second series to an existing chart, how is it done? (I am comparing accidents in 2006 and need a series line for accidents in 2007) Thank you,
|
| Force X Axis Label | 08 Feb 2007 15:39 GMT | 3 |
How do I force Excel to Label every bar on a bar chart? I have a simple bar chart that I would like to have the X Axis Label on every bar except Excel skips and labels every other one. How do I force it to label each one?
|
| Charts forget range or data; fixed by manual alteration then Undo | 08 Feb 2007 15:23 GMT | 1 |
G'day, everyone. Two of my charts recently stopped displaying properly. When I refresh the data behind them, the automatic X axis drops most of its range and the chart either stops drawing most the ranges or collapses them to
|