Search results for query: *

In xl2003 you can use this technique to copy and paste a transparent oval to the series. http://spreadsheetpage.com/index.php/tip/creating_a_transparent_chart_series/

Double click the axis and on the patterns tab set Tick Mark Labels to Low.

To add information to the addin such that it is displayed in the Addins dialog use the Title and Comments field of the documents properties. You may need to do this before saving your xls to an xla. Or temporarily set the Thisworkbook property IsAddin to false so you can use the menus File >...

Hi, From the help, On the Tools menu, click Options. Click the Other tab, and then click Advanced Options. Under General Settings, next to the Startup in this folder box, click Browse. In the Select Folder dialog box, select the folder you want to appear when you start Microsoft Outlook.

Hi Skip, I read the whole question differently from you. Your autofilter technique would be used to change the quantity of data displayed where the question is about changing the values displayed. And the textbox link is to a cell that contins information that is not itself plotted within the...

Your reply does address that part of the question. If does not though answer

Here is an explanation of linking the chart title to a cells. http://www.andypope.info/tips/tip001.htm The same principle can be applied to other chart text elements and embeded textboxes.

Have a look here for a collection of examples of how to create a clustered/stacked chart http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html Cheers Andy

Hi, Sounds like you have selected the stacked line and area charts. In order to get a series on to the secondary axis you must have minimum of 2 series in the chart.

Hi, You do not specify a range or text for the axis labels it defaults to 1,2,3,4 etc up to the number of data points. Right click the chart and bring up the Source Data dialog and then clear the Category labels range.

Hi, Double click the data labels and check the setting of 'Right to Left' 'Text direction' on the Alignment tab. Maybe it is set to Right to left. Cheers Andy

Hi, Deleting the labels by hand is indeed an option and depending on the size of your problem may well be less work. In fact if you select the series and then select the last point you can then use the format dialog to apply a data label to this single point.

Hi, You can create the shaded effect by using 2 extra data series plotted as an area chart. There is an example here. http://www.andypope.info/ngs/ng21.htm Cheers Andy

Hi Messsp, Skip's suggestion will work. It sounds like you didn't have the column series selected when you pasted the autoshape. Therefore rather than been used as a fill it is simply a object within the chart. Cheers Andy

Google groups to the rescue ;)

Hi, See this MS kb article. Pictures in documents that were created in an earlier version of Office appear flipped in Office XP and Office 2003. http://support.microsoft.com/?kbid=312838

Try Tools > Options > View. Objects should be NOT be "Hide All"

Hi, It's not a shared workbook is it. Cheers Andy

Thanks Ken.

Hi Ken, Yes its me. Just doing one of my flyby posts :) Cheers Andy