| Thread | Last Post | Replies |
|
| Fixing Cart Data Range | 04 Feb 2004 15:43 GMT | 2 |
I have chart data that is in columns. To add new data I insert a row a the top of the data range. When I do so, the chart data range does no pick up the new row, it actually moves down with the original top row. I have to manually move the data range up to include the new row. Ho
|
| trying to show totals on chart | 04 Feb 2004 13:37 GMT | 1 |
i have a list of dates, each with an associated category and time in minutes. Categories occur more than once in the list. I want to show the total minutes for each category on a bar chart, however I am only able to show each individual occurence, along with the time on my ...
|
| Changing a series' Name, X- and Y-values by using its series number | 04 Feb 2004 13:32 GMT | 4 |
I can change the name, X- and Y-values in series #1 with the following code: ActiveChart.SeriesCollection(1).Name = _ strNameSeries ActiveChart.SeriesCollection(1).XValues = _
|
| Area chart with vertical lines | 04 Feb 2004 12:35 GMT | 1 |
I am trying to produce an area chart with vertical lines to cross at certain points on the horizontal axis for illustration purposes. Does anyone know of a better way than just drawing them on I would ideally like to be able to have three fixed lines and one variable one that is ...
|
| Rolling dynamic data range | 04 Feb 2004 09:19 GMT | 3 |
I have 2 adjacent columns of data that my chart is based on. This data is continually expanding downwards. I want my chart to always reflect the bottom 10 rows of data without having to manually change the source references
|
| Movie of Charts desired | 04 Feb 2004 05:13 GMT | 2 |
I'm having alot of trouble trying to show charts repeatedly. I change the data that is the 'source' of the chart, but even with a 'refresh' it doesn't want to show anything, till the last one. What gives? Any general hints or clues appreciated.
|
| How do I change chart data to display by rows in 97? | 04 Feb 2004 03:08 GMT | 1 |
How do I change chart data to display by rows in 97?
|
| Grey box | 03 Feb 2004 21:46 GMT | 2 |
I have a workbook with linked sheets and charts on each page. Suddenly unless I have clicked onthe chart, it shows up as a grey box. It also prints as a grey box. When I click on the chart, it looks fine. any suggestions?
|
| Trendlines in a column chart not showing | 03 Feb 2004 21:20 GMT | 1 |
I cannot get my trendlines for mass moves and disposals to show up on m chart although they show on the legend. Why and how do I fix it Attachment filename: new archival ssus cumulative 2003.xls Download attachment: http://www.excelforum.com/attachment.php?postid=42988
|
| Combining clustered and stacked column charts | 03 Feb 2004 16:02 GMT | 2 |
I am trying to plot a set of cost data. I am looking at planned cost versus actual cost (clustered) for several projects. Both the actual and the planned costs are made of several different types of costs that need to be noted
|
| Multiple X-Axis | 03 Feb 2004 14:27 GMT | 2 |
Excel is set up to plot one X-axis against two y-axis. How do you plot one Y axis against multiple X-axis?
|
| Grid Lines at begining of every year? | 03 Feb 2004 12:58 GMT | 1 |
I have a 10+ year chart, starting June 1992 and ending Dec-2003. I want the vertical grid line at every Jan-1st and the axis labels Jan-93, Jan-94, Jan-95 etc. Right now, they are June-93, June-94 etc.. Thanks.
|
| Charting oone number, displaying another | 03 Feb 2004 12:52 GMT | 2 |
I have a line-combo graph that is graphing one number, but I need the number in another call to be the number displayed on a chart. IS this possible? If so, how?
|
| Saving chart as an image file | 03 Feb 2004 12:52 GMT | 2 |
I want to create a pie chart in Microsoft Excel, then save it as an image file (.jpg or .gif) so I can put it on a website. How do I do this? Secondly, as I create my pie chart, how do I set my data
|
| Excluding certain rows from being included in diagram | 03 Feb 2004 12:50 GMT | 1 |
I have a table (from which I produce a number of graphs) that begins as follows Order No. Requote Change Requote 280
|