I am using pivot charts to plot events over time for various vendors. The problem is that if there was no occurrence for a particular month, that month is...

Alan - You have two issues. To prevent the fonts from mucking it up, you need to disable font...

How are the axes already in use? Are they tied up by the XY series Bernard uses for the category axis? Do the added lines reflect the same scale as are used in...

I have some very simple data that I need to compare in an XY scatter plot. There are about 10 data points (2 digits with one decimal) from 1994 and the same...

Try this in your code: "0;0;""""" which produces: 0;0;"" - Jon -------

HI All, Is there a way to link a chart title to a cell value? Thanks for your help. Regards Romiz

I have a .NET project that updates XML data in an Excel template. The template contains several charts. I have set the colours for individual bars on bar...

Hi, I'm new here so excuse any ignorance - other than the question itself! I have 350 year 7 test scores ranging from 5 to 23 out of 25. I have arranged them...

I am a new user of excel and I need to create an s.p.c./standard deviation chart for a process but I have not got a clue as to how to setup or create this type...

I am working on a line chart to plot weight gain for pregnant women. The chart consists of two lines that follow the same slope and then splits into two...

Great idea, but not easy to do... There are no Event Procedures for Chart Series or Points in an Excel Chart - just for the Chart itself. In other words, you...

I cannot de-select "Chart sizes with window frame" in Excel on Office XP Pro. I am working on a new laptop with 15.4 " screen (1280 X 800 resolution). In...

I'm helping my brother with a presentation for school. The problem is when I enter the dates in the form they are ok but when I create the chart it makes all...

Hello all, I am using excel with phstat add-in to create the mean, median and mode for some data. The mean, median, and mode occupy 6 rows and two columns in...

I am trying to convert the Chart series formula below to an array via VBA. I have tried recording a macro and have had no success. I used the select series,...

Hi Andy, Take a look at Jon Peltier's examples of conditional charts. (http://peltiertech.com/Excel/Charts/format.html#CondChart) Cheers Andy andy2004 ...

Hi, I would to realize with excel an X/Y line diagram where on the X axis I would put a date/time value. There is anyone that know how to do this? We suppose...

Jill - Excel XP or 2003, right? In prior versions the labels would show if the point they represented fell outside the plotting rectangle but still within the...

I'm using excel with phstat add-in. How do I graph so that the units of the variable are along the x-axis and just the count or frequency is along...

I have 2 sets of data (order qty and forecast qty) that I would like to chart on a line graph. x-axis by month, y-axis by quantity. The forecast qty line...