Hi, I keep a rough weekly diary on the development of a certain numeric
value. Now I've got a series of data entries in a chart as follows:
A1 - date of entry, eg. "23rd July 2006"
A2 - reading data value, eg "100"

I recorded the following macro and I have no idea what the following
numbers in () are.  Could someone please help?
ActiveChart.ChartArea.Select
With ActiveChart.TextBoxes.Add (338, 207, 374, 16)

Has anyone any insight on changes to the charting options in Excel 2007?
What I have found emphasizes integrating the excel charting with word
and powerpoint and fancy chart themes.
But there's nothing on any new chart types, like boxplots

* Sorry this has been posted in the "General Questions" forum but have placed
it in the incorrect area.
Morning All,
Now I'm not sure if there’s a simple answer here but I sure don't know it!!

Graphing in Excel - I have six years worth of data.  The 'Fiscal year' is
along the x-axis, and 'Dollars' is on the y-axis.  There are two sets of data
(with three dollar amounts)for each year.  The first is for the corporation
overall, and the second is for one business unit ...

I want to create a Chart that does not directly reference cell-ranges (i.e.
A1:A6),
but excel-names that make the reference sheet-independent.
My aim is to be able to copy one chart to other worksheets, which have their

Basically i want to create a scatter plot using the data provided
below... but i want the x axis to go by month and then have a year
marker...  all i can seem to get is either all the months, or all the
years, but not both together...

I am running a loop in VBA which is supposed to draw a new chart fo
every (2) column(s) of data.
However, I am not sure how to make it "jump" from column to column.
Part of my program (does not include the "For i=1 to3 e.t.c.) is below

Under Format/Cells/Date (or Time) I can pick a Type as 3/14/01 1:30 PM. And
entering that within a cell works fine. But if I try to use that column as
the x-axis of a graph it only supports the date. For example a value for a
reading at 3/14/01 1:30 PM and one given for 3/14/01 2 ...

I have the following data to chart (Using Excel 2003)
It's for several different hospitals and I want a chart for each hospital.
I want to compare 4 quarters from the year 2005 & 2006 (side by side) in a
bar graph for each year and then the YTD data as well (side by side).  The

Is there a way to move data labels. I have negative and positive values on my
chart and it caused the axis to move up, but so did the labels. and now the
lables are in the middle accross the data points. looks busy.
is there anyway to have the labels display on the bottom of the ...

Hi every body,
Can you please help me with this confusing issue?
My data is preseted in a scatter plot and the trendline is shown in the
figure. The R square value from the trendline option is not the same as

Various special charts (floating bars etc.) make use of invisible bars
(bars without border and with no area color). How can I access such
bars to change them back into visible ones? I can have them marked by
clicking on an adjacent bar and using arrow keys to locate the next

I'm trying to create a chart using the same cell reference in several
worksheets. Does anyone know a quick way to do this?

I select a chart which is embedded in a spreadsheat.  I click on the printer
icon and click on "OK".  It prints a blank page!  I repeat the process and
look at the preview.  It looks okay but still prints a blank page.  I then
double click on the "Selected Chart" toggle under ...