Hi, I have a worksheet containing daily data relating to web site page hits and want to chart this as an open-ended graph on a Chart sheet. For example,...

I'm trying to create multiple pivot tables from a large worksheet using the show pages feature in pivot tables. I create the page worksheets and pivot tables...

I'd like to have charts pop up when the user hovers over the source data. For instance, I have several sections of sales data in this form: Jan Feb Mar ...

I have a line chart that plots percent progress (0% to 100% up the Y axis) over a 10 year period on the X axis. The data is quarterly. But I only show tick...

I want to code a "linefeed" on a Title, but when I do that, it opens up too much "white space" between the 1st & 2nd lines. Is there a way to get around...

I'm running XCL'02 and have to make hundreds of charts that are all going to look the same but just have different ranges of data feeding them (similar ones...

I want to enter a number into a cell and this number will automatically add its value into another cell. However, after the pressing the enter key, I want the...

I have had a chart for some weeks now that I update periodically. It is a simple line chart. When I opened the chart today, my data series points were all...

Hi, this is my first post on this newsgroup... so i introduce myself: i'm a IT technician and i work for an italian enterprise (so sorry for my...

We currenlty use Excel Charts where the Source Data is linked to another workbook. The Number Formats are not carried over correctly from this Workbook unless...

Hi every one...i've been racking my brain out on this one. I'd like to come up with a way to display things better. Background: I am making a running...

I am using MS Excell to make bar graphs which I then import into a Corel Presentation WPG file. I am doing this using the clip board, inserting the graph as an...

When trying to create a custom chart, there is no add button after choosing user defined in Excel 2003. Has anyone seen this issue. It is the same on 3...

I am trying to draw a trendline for a data series which used a secondary y-axis. It's looks as though the setup for the trendline is working okay, but the...

Loss of formatting is a known problem with pivotcharts. There's some info in the following MSKB article, which suggests recording a macro as you apply the...

Hi, How can I put the char's Series value as column value instead of sheet name in the marco? I have 7 sheets (Jan04,feb04...) and 8 charts on each sheet. I...

Come to my rescue again! I have a Excel 2000 worksheet showing customer satisfaction results for our dealer network. I want to give each individual dealer...

does anyone know how to format a pivot table so there are no blank cells? see below I curently get type A X 12 Y 20 Z 32 type B ...

I have an XY scatter chart that shows a percentage on the y axis and the month/year on the x axis. The January label/tick mark is right on the y axis. However,...

I would like to plot 8 to 10 data series in one graph. However there are huge differences in the y-axis for one data series in comparison to the other data...