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

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

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

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

I have a bubble chart that plots 7 business opportunities as follows: a) Attractivenes on the Y axis (10 lowest, 100 highest) b) Probability of success as a %...

The user has asked that the darkest colors and specific symbols be used for readability of the chart: Black is the most preferred color; white is the...

I would like the chart to update automatically when monthly data is entered. Every 1st of the month I update the data to add previous monthly values. I like...

Dennis, Excel certainly supports multiple monitors. I have Excel 2003 running on 3 19" flat panel displays (controlled by a Matrox Perihelia 256MB card). You...

I have the task of charting daily flight information, but I'm having issues charting some of the data. A sample dataset looks like the following Flight /...

Does anyone know how I can get the area under the curve for a graph I've created?

Create a pivot table with Date and Location in the Row area, Type in the Column area, and Date again in the Data area, where it will become Count of Date. In...

Use a PT to have XL sum data within specified groups. The Time would be a row field and the Customers would be a data field. Ensure XL uses 'Sum of...

Hi NYBoy, Check out Jon Peltier's example. http://peltiertech.com/Excel/Charts/DynamicLast12.html Cheers Andy NYBoy wrote:

I'm using excel for my calibration lines. Excel can give the formula of the line. I use this formula to calculate the unknow values. I have to put the formula...

Use something along the lines of: Sub testIt() With ActiveSheet.ChartObjects(1) .Left = Cells(3, 3).Left .Top = Cells(3, 3).Top .Height = 200 .Width = 300 End...

I have a graph with four series but some of the series may be blank, i.e. the series name is blank series. Is there a way to not display these series on the...

Hello All, I'm working with a table like this A B C 1 Quantity Quality 2 Vendor 1 4.3 2.3 3 Vendor 2 5.2 4.1 4 Vendor 3 6.1 5.3 5...

Hi, I want to change the Y-axis width, and the suggested method from "Help" is to select a data series and use an option from the appropriate Format menu....

Hi, What is the quickest (and most efficient) way to do the=20 following: I have a set of data, which is a set of Rental Rates,=20 varying between a minimum...

After much time by me and assistance by people in this newsgroup, I am almost finished what I confidently expect to be the only chart I'll ever produce in my...