Does anyone know how I can get excel to display the total
in a stacked bar chart?  I tried the solution that
someone posted for a stacked column chart, but that
doesn't seem to work with stacked bars.  The third

This is probably a very simple problem to solve, but my
statistical knowledge doesn't cover it, unfortunately.
I am producing charts linking average car ownership to
average dwelling size for a large number of small

I am trying to create a chart which shows the following:
3 series of data:
1-number of permanent staff
2-number of temporary staff

I have a chart that I input data into on a monthly basis.
The chart currently goes from 8/31/2002 until 1/31/2004.
I want to only show the most recent 12 months worth of
information but I don't want to lose the data from the

Using the same source data, how can I create a pivot table and pivo
chart on the same worksheet?:rolleyes
--
Message posted from http://www.ExcelForum.com

How do I rename a chart without using VBA?  (Not renaming
the chart title, but the way Excel refers to it e.g., in
ActiveSheet.Shapes("Chart 1").)  Appreciate any help.  
Can't find the answer either in Excel help or online

I'm sure there is a fix for this, but it is evading me...
I have dates as data points on my "X" axis and when I use those dates to
create my chart, Excel wants to put a range on the axis instead of the
actual data point dates.  Any way around this?

Is there a way to create an XY line graph wih plotted
data, yet leave room to predict future data on the axes?  
I can get the graph, but the x and y axes stop at the last
data points, and I want those axes continued so that the

I'm trying to write a sub-procedure that creates charts based o
variables entered from a userform. Two of the variables specify a dat
range for which the graph should plot. This therefore means that I nee
to use two ranges within the source parameter of the SetSourceDat

I've created a very useful PivotChart.  It sums up the areas occupied by business units for each floor in a building.  The Chart Type is Stacked Bar.  The Page Field is the Building.  The Category axis is the Floor.  The Pivot sums the square feet occupied by each business unit.  ...

It's been a really really long time since I've used Excel, and now
need to create charts based on data I've been tracking, however,
can't seem to make the charts represent the data in the way I need fo
it to show up.  Attached is what my data looks like: (also I need

Hi people
I have encounter a problem with the use of range
From a recorded macro, it's listed this way
ActiveChart.SetSourceData Source:=Sheets("Trend").Range("A1:M2,A24:M28"), PlotBy:=xlRow

Hi people
I had tried using Marco Recorder to get the codes required for plotting a chart
It appears that the codes are given incorrectly, there are certain part of the codes have runtime error
===============================================

I was wondering if there is a way to extend the X and Y
data ranges on a line graph?  I am plotting some data, and
I want to be able to extend the x and y axes so that I can
predict future vaules, however I cannot seem to figure out