I have a line chart of a spreadsheet with one column of dates and three of data. The date column is sequential, not contiguous (i.e., dates are skipped), but...

I have a spreadsheet with multiple tabs for entering daily data - to populate a chart on each tab. The spreadsheet data is backed up & then wiped...

Hi all, I searched the archives, but am searching no good I think. Is it possible to enter 2 independent graphs on 1 chart sheet? I'm not referring to...

I have drawn an XYscatter chart connected with smooth lines. I want to get the corresponding value on X axis at a know value of Y (50%) how can I do it? Is it...

Hi, everybody, I have just found this newsgroup and I wonder if anyone could help me with a problem that has suddenly turned up: I run Excel in an Office97...

I am trying to refresh a chart in an Excel 2000 worksheet without recalculating the whole worksheet. Tried using the following syntax to no avail (this is not...

I created a pivot table which shows the both individual and grand totals based on the fields I selected. I then created a bar chart based on this pivot table....

I have several Excel xy charts plotting data that updates automatically. The x range varies from 0 to 40, 40 to 80, ... up to 560 to 600. I want the chart x...

Hi all. I have a question on printing our charts. I can print out a chart on a printer and scan the printed chart to get a .pdf or a .tif file format. Is...

How do you show two value ranges of the same data on one axis? (the axis range is separated by a zigzag/heartbeat style line). e.g. instead of showing 0-50,...

I wanted to make a 3-dimensional plot in Excel and discovered that I cannot do this. All you can do is make 3-D charts over two dimensions, you cannot make...

I have a power user who wishes to increase the size of his 2-D graphics but is limited to using 32000 records. He needs to be able to use 64,000 records. Any...

I have a line graph with values for years. Between the years 1998 and 1999 there was a coding change so I don't want the line to connect the points for those...

Hi All, I have a problem with a stacked chart in excel 2000, i have used the search function but could not find a solution. The problem is as follows: I...

I need to display a data set on a dual axis clustered stack chart. It needs to be sorted by month for a six month period, with two groups of data, each with...

Hi, I have two columns of data that I want to plot against each other as a scatter plot, e.g. column 1 is the x value and column 2 is the y value. The values...

Apologies if this is posted in the wrong Excel section. I own a small chemical company that analyses various products for chemical impurities. I have...

How do I change the size of a data label in a pie chart? I am getting unusable wrapping of text when I have plently of room if I could only resize the label...

I'm using a simple bar graph with a data table. The data table is in the opposite order of my graph. I've tried resorting the source data, I've tried reversing...

If I want to change x-values in a multi-series X-Y scatter I have to edit x-values seperately for each series e.g i have 7 series - i have to edit all 7...