Hi recently I was trying to create a userform where I was giving the value of text box to a cell. The textbox value was more that 255 chars and I used...

Use #N/A instead of "" for null values. Jerry Bob Barnes wrote: I have Souree Data for a Chart with some Null Values. However, they appear as Zero on...

Excel 97. Can anyone spot where I'm going wrong? I'm trying to change the source data in code so it only shows upto the last cell that has a value in it. My...

I have a spreadsheet where I enter time line data in the cells and from that information generate a Gantt chart. What I would like is a way to have symbols on...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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

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.

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...

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...

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...

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