Andrea - I've never noticed this behavior, but you're right, custom user-defined charts don't support invisible chart area formatting. The best I can suggest...

I am plotting data on a monthly basis for a year from the result of some calculations in the spreadsheet..... So when it's April the values in the rest of the...

Suppose your data are in A1:A60000. Then, in B1, enter =INDEX($A$1:$A $60000,(ROW()-1)*2+1). Copy B1 to B2:B30000. Plot B. -- Regards, Tushar...

I'm using openoffice which is the same as Microsoft Excel It's the same, only different. Why are you charting dates on the vertical axis and measurements...

Hi, There is no automatic way to do this but take a look a Tushar's AutoChart Manager for a possible...

Is there a way to connect the plot points in a line chart when the plot points are a calculated point? In the pregnancy weight gain chart that I am working on...

Terminology: This is a 3rd order polynomial, not a 4th order. Caveat: Unless you have external knowledge that the form of your model (cubic in this case) is...

I am using a bar graph to display a list of projects where each project has a start date and an end date. The chart is set up for a 3 year time frame with the...

How do I reduce the size of the chart area? I've made the plot area smaller and would like to decrease the white space in the chart area. Many thanks.

How can I count the number of series in a particular chart using VBA. I have tried ActiveChart.SeriesCollection.Count but it doesn't work. Thanks

Hi Leanne - I don't see UpdateSPWebLinks in my VBE Object Browser. It must be part of a third party solution. When you installed everything on the...

Does anyone know how to determine the area under a curve from an Excel chart??? I've tried to use the "Area Chart" function in Excel but I can't find where it...

Is it possible to build two pie charts (side by side) in one chart sheet? Thanks --- Message posted from http://www.ExcelForum.com/

Hi, I'm using Excel 2000 and have a number of worksheets with which I've created some charts (all in the same workbook). Is there a way to print the charts...

Follow your instincts, and use numbers for states, {1,2,3,4,5} for {A,B,C,D,E}. Make your chart. Then use the technique on this page to put the labels where...

Greetings, A bunch of us are re-introducing ourselves to Excel 2000 at work and so far doing alright. We have noticed, however, that while we're editing...

I am going to assume your x-values start in A2, y-values in B2, all on Sheet5 Use Insert|Name|Define and define MyX...

I am using Excel 2000. And, I need to count cells that fall in multiple criteria. For example, I have 5 numbers 93.84, 100, 95, 92.5, and 92.5 in cells from...

Hi All, How is it possible to select a data range by using variables? i.e. instead of range(A:1,c:3) have range(i,j) Here is my code, the line with the...

In a frequency histogram the area represented by the bars in the chart is area proportional, if after the histogram is created it is converted to a radar chart...