Many thanks. You solved my problem. And thanks for the link to your excellent website.

Hi all Is it possible to add an excel chart to a PowerPoint presentation as a linked object using VBA (or via an external VB6 app). I want to achieve the...

Hi, I have a problem in printing Chart with background pictu The Chart type is Clustered Column with a 3-D visual effect. I right-click the background and...

Rollin - The date format problem happens because the axis formats are probably linked to the source data. As long as the source data is in an open workbook,...

Zach - Use an XY Scatter chart instead of a Line chart. See these links for more information: Scatter Chart or Line...

In XL, turn on the macro recorder (Tools | Macro Record new macro...), change the y-axis scale maximum by hand, and turn off the recorder. XL will give you...

Hello -- An external application generates a text file which looks like the text between the lines: ----------------------------- ARRAY 1...

I used the chart wizard to put a chart on my excel spreadsheet. Print preview shows it in color but it prints black & white. I verified that the black &...

I am trying to chart a worksheet that contains many formulas. When the result of the formula is zero, the cell is instructed to leave the cell blank (which is...

There are two approaches. First, make a custom chart style. Make a chart with all the formatting you like, then choose Chart Type from the Chart menu, choose...

I suspect, though I am not sure, that you will have to buy MS MapPoint or one of its competitors to get what you want. -- Regards, Tushar Mehta, MS MVP --...

HI I am trying to create a chart and trendline for a data set to be used for interpolation/forecasting. Following is the data set: X-axis Y-axis...

There are ways to simulate the effect. See the 'Broken y axis' page of my web site. However, what you are doing is probably much more efficient. You can...

Using Excel 2000: Hey all, I have two tables and want a line graph based on one row, but with the values of another row: Votes: ------

Reading an Excel file that has been saved from previous version of excel. Stored on a network drive. At opne, receive a pop up error message: Fie Error -...

How do I change chart data to display by rows in 97?

Hi one way: define a name (goto 'Insert - Name - Define Name'). e.g. the name: chart_range: =INDIREKT("A1:A10") to chart the first 10 rows of column A and use...

Hi Rachel, Take a look at my Averageline example, there is a section on adding lines to an area...

-----Original Message----- PLEASE HELP I have not been able to receive help. Probably the question may not be clear. I am once again putting up the...

I've created a chart with X Axis Category labels--they're months, Nov-03, Dec-03, Jan 04. Beneath the rightmost X axis, though the chart data points are...