Hope you all can help, i've looked everywhere but have found it very
difficult to achieve what I want. I'm not familiar with VB but i know
how to copy and paste into modules!
Here is the data (column by column):

I am writing a macro to create a xlColumnStacked ChartType. I'm asking
Excel to show the series values inside the column wthout borders or
fill:
   For i = 1 To .SeriesCollection.Count

Hello From Steved
I have 2 spreadsheets one is Called Auckland and the 2nd is Called Wellington.
My Objective please is to use the data from 2 spreadsheets to create a
single Pivot Table. Yes this is one workbook with 2 spreadsheets. is this

How can the task of adding 'error bars' to a graph be simplified with excel
2007. In excel 2003 it is done way easier, almost just by double clicking the
graph. In the 2007 version you have to walk through menus and then more menus
to get the task done. When one has to do this ...

I am now using Excel 2007.  Excel 2003 had a format data series fill effect
of "Pattern".  It allowed selection of various line and dot patterns for a
stacked bar chart for example.  I can't find this "Pattern" data series fill
effect in Excel 2007.  Has it been removed?  Thanks!

I print multiple graphs for meetings and it takes up quite a bit of paper.  
Is there a way to print two graphs on one page?

I am trying to show on a bar chart the baseline that represents SLA
requirement of system up time of 98%.  How do I do this?

I am plotting a weightloss series with weekly values.  I currently have the
horizontal (subject) axis values labeled with a series of dates from the
spreadsheet.  I have set the date axis labels at the bottom.  How can I add a
second set of labels at the top for the same axis?.  ...

I have read several questions and answers on this subject but I cannot get
them to work. I have Excel 2003. What I want to do is to place a text box on
the graph where it equals a cell outside the graph and changes accordingly.
The posts I have read say to select the graph first. ...

How do I draw a Security Market Line in Excel?

I have some zero values on my pivot chart and, as far as I know, I don't have
the option to hide the zeros or get rid of them.
How can I get rid of the zeros?

I have 10 patients who have had blood test X measured on different dates
through 2007.  I'd like to plot all 10 lines on the same graph showing the
variability of the data points.  I can plot all 10 patients' data but versus
only one patient's set of dates.  Any suggestions as to ...

I have got to do this for a class but i have no idea what they are asking me.
How do I create an apple to apple chart and then an apple to orange chart on
Excell?

By way of background, there are multiple charts on a page, with a
separate header which is a picture. The charts have no borders and
'float' on a grid which is the same colour as the chart area. The grid
has borders round groups of cells and these form the borders for the

I want to have multiple, vertical stacked columns for each X-axis data
marker.  Is this possible?
I'm using Excel 2003.