| Thread | Last Post | Replies |
|
| How can I export charts as graphics sequentially? | 25 Oct 2005 11:51 GMT | 2 |
I'm trying to export a number of graphs (as gifs) from a single worksheet. I was planning to automatically name them sequentially i.e. export1.gif, export2.gif etc, based on their position on the
|
| Title Block in Excel Chart - Size problem | 25 Oct 2005 11:45 GMT | 1 |
I have a problem with the y axis title block. In my Excel 2003 it does not auto size nor can i change the size. This results in the titles that i place being chopped off and graphs looking somewhat dumb. any ideas
|
| graph | 25 Oct 2005 11:39 GMT | 1 |
i have five worksheets and i want one figure from each to produce a chart. i have put in the following but no joy. 'March 2005'!$B$28,'March 2004'!$B$28,'March 2003'!$B$28,'March 2002'!$B$28,'March 2001'!$B$28' Any help please
|
| High bars | 25 Oct 2005 10:51 GMT | 1 |
In Bar Charts, when values (height) of a or a few bars are very higher than others, maximun of y-axis is very high than general values. Therefore general bar heights become very short. Is it possible to show these high bars by cutting and adjusting y-scale.
|
| Hyperlinking to charts | 25 Oct 2005 10:50 GMT | 1 |
I have a Chart within a workbook that is its own worksheet (as opposed to being an object within a worksheet). I would like to hyperlink to this chart from another worksheet. However, when I choose Insert Hyperlink, the worksheet representing the Chart does not appear as a "Place ...
|
| Stacked bar for multiple series + secondary axis | 25 Oct 2005 08:02 GMT | 2 |
:confused: Could somebody help me to get 2 or more parallel an distinct stacked bars? In the attached picture you will see that th only solution I got was to modify the bar width. Thank!!!!!!!!!!!!!
|
| Statistical graphing - enhanced box&whiskers | 24 Oct 2005 23:19 GMT | 1 |
How do I plot points for data for 2 categorical series, A and B on X-axis and the values on Y axis, such that each data point is individually displayed (i.e. by looking at the plot, I can see how many in each category had a value y, and then add in a box-whisker plot to show the ...
|
| Scatter Column chart ? | 24 Oct 2005 23:16 GMT | 8 |
I have data organized like this: Range Value 6-8 5 8-12 1
|
| How To: Link worksheet data to pre-existing chart tables | 24 Oct 2005 23:06 GMT | 4 |
I have a powerpoint presentation which has all the required excel data charts in it already. Currently to update the charts I need to pick the appropriate data out of seperate excel worksheets and manually input the data to the appropriate charts that generate the charts. How do ...
|
| Excel won't let me uncheck Size with Window | 24 Oct 2005 21:49 GMT | 2 |
I have tried both on the View menu and in Tools/Options/charts menu. I have also tried using VBA ActiveChart.SizeWithWindow = False but the property is still TRUE. Is there something other setting the forces this TRUE?
|
| how to convert lotus 1 2 3 data and graphs to excel 2000. | 24 Oct 2005 20:18 GMT | 1 |
I've tried 'save as' option and 'open, file' option. The data is converted but the 30 odd graphs are not. Regards Martin
|
| pie chart percentages are not right! | 24 Oct 2005 20:17 GMT | 1 |
Maybe I'm overlooking the obvious...but when creating a simple pie chart with 2 columns of data...the resulting chart has percentage values that are way off. Below is the data...for example...in my pie chart...the value for "449900" shows as 7%. Why?
|
| Pivot Tables | 24 Oct 2005 18:24 GMT | 1 |
I have a userform, and it has 2 textboxes, is there a way that I can write a macro that will only display that data on a pivot table between the 2 dates entered in these textboxes? Right now I have the below, but I don't want to have to have all the
|
| Excel: Can I change Chart-title/category/value from a sheet-cell? | 24 Oct 2005 16:55 GMT | 4 |
Changing the "Chart Title", the "Category (X) axis" and the "Value (Y) axis" via the change of a worksheet-cell would be useful. Does such a utility exist?
|
| How do I put a 0 in my pie graph? | 24 Oct 2005 16:20 GMT | 2 |
I need 0, 1, 2, 3 and 4 as my secondary value but Excel always changes to 1, 2, 3, 4 and 5. Thanks in advance, Nivek
|