I'm trying to chart the following spreadsheet layout:
Expr2           FinancialClass    SumOfTxnAmount
January, 2003    M    $145
January, 2003    C    $1432

Is there any way to group dates into weeks in pivottables
and pivotcharts, instead of just days, months and
quarters? Thanks in advance.

Every new pivot chart report I create from a particular pivot table
refreshes all the previous charts (which are on separate worksheets) to
contain the same data.  This is driving me nuts.
I have created a pivot table  on a new worksheet.  Then using the

Thanks Jon, I am trying to copy and paste the data in columms A,C and
into each text box that was selected in columm E. (by the code yo
described)Thus, data for example from A1,C2 and D1 will be pasted int
the text box appearing in E1. And so on.... So a code that will do tha

I plotted data from lab measurements on an Excel chart,
then asked the program to create a trendline for the data
and display the equation for the trendline on the graph.
The only problem is that the equation Excel produced is

I've been requested to create a hisogram.  I have no idea
what chart to type use and where to place the data.
any suggestions ?

in a simple line graph, the line is displayed as zero on
the chart when the source data cells are blank.  How can I
make the chart not display the blank cells as 0?

still no luck trying to follow
http://peltiertech.com/Excel/Charts/AddLineVertSeries.html
when i create and paste special the new series, the one that should end up
as the vertical line,

What would a code that would say:
Select all the text boxes in columm E......
Thanks,
B

I am attempting to plot two sets of data (x1,Y1) and (x2,y2) on a
combined scatter chart. BUT (x1,y1) data is not in the correct
orientation I need to present it so I have to reverse the x scale so
that it read from right to left . . .4, 3,2,1,0 so zero is at the far

I'm trying to chart a stress-strain curve in excel, and I
haven't been able to show 2 scales on the x-axis, one for
the low range, 0-0.002, and another for the high-range
0.002-.6.  Any help with this would be appreciated.

After working up a good workbook, with column sizes changed and margins
changed and page breaks changed, I tried to then copy and paste it into
sheet 2, however, all the formatting I changed, was changed back to the
default excel settings.

I am plotting 5 data series on the same line chart. Dates are plotted on the x axis and concentrations of chloride on the y axis.  The dates are formatted like "5/12/2003"  as "general" data in the "alignment" menu of "format".  The trick is, each data set does not have the exact ...

I have Microsoft Excel 2002. I have 10 minutes worth of data (a
object's change in position in x and y)  that I want to plot as
function of time. The time function, recorded with an accuracy of .01,
is recorded with the positional data. How do I graph the positional  

I have the following problem:
I have 15 cities for which I have two data values for 4
dates (example: Vienna 1950: 10 90  
                      1960: 50 50