All,
With VBA I'm making a chart sheet.
This chart sheet is than viewed by the user. I have protected this sheet, so
he can make no changes.

Dear all, maybe you can help me. The situation is
following: I have attached the data to chart, but when I
did some changes in these data, in chart these changes was
not done. And also formulas does not work - actually in

Hi all! I am trying to create a percentage chart.  For example, if the total is 76, but I have 36 of something, the height of column bar should be 76 and 36 of it is some other color, and at the top of bar should display the percentage of 36/76.  How do you do it? thanks!!!  And ...

Does anyone know if it is possible to plot 2 series of
stock data on 1 graph?  In other words, I'd like to take
2 sets of H-L-C data, and then create one graph with
primary and secondary axes for both X&Y, that would

I am using the speedometer combination chart as shown by Jon Peltier.
Excellent tips!
Is there any issue with this type of combination chart with Excel 200
/ XP and saving in html?

I am using Office 2000 SP3. I have problem zooming in the
charts in Excel. The zoom button is grey out on both
formatting bar and under view -> zoom. In order to zoom
in, I have to de-select "sized with window" under view.  

I have heard this is a download that will enable me to
add markers/lables to points on a graph that are NOT
either of the co-ordinates of that point.
I have had a good long look on the downloads site but

If I have data entered in a spreadsheet,
can I have the spread sheet draw trend lines,
but nothing else?
TIA,

there is anyway that i can make a chart to have the y axis
but for presantation reason i want to make y axis not to
appear, or make it white. If it's not cal i hide the
values of Y axis, either disappear them or change the

I'm hoping to find some help in here:
I'm trying to make a diagram showing to rows of data. However, I wish
the two rows to be handled as one row. The two rows give me two curves
in the diagram, but I only wish one.

Some time ago, Ron Peltier, in particular, gave me a lot of assistance on
attaching labels to points. However, the method that best suits
me for XY ("scatter) charts came from a suggestion by "Andy Pope"
<andy@digitab.demon.co.uk>  who mentioned Rob Bovey's XY Chart Labeler which

This seems pretty trivial but I cannot find a good solution yet, I have
3(or more) columns and I highlight them and line-chart them and get all
the points in a one-page chart. I found out if I use the chart as
another sheet I can stretch it by it doesn't look right.

My problem is that I have a chart that I am creating a chart of tota
sales for new molds and products for our sales engineering guy for eac
year 99 to current.  No problem, right?  Wrong!  He wants each bar t
be broken down in to top customers to show where the sales came from.

I'm having trouble plugging the equation from the trendline of a chart
back into the Worksheet to get calculated interpolated values. In
essence, I added a 4th order polynomial regression line to an X-Y
chart, and then used the displayed equation in the worksheet, working

Can you draw objects on an excel chart? I would like to ad a vertical line in cwertain places to label an event on a time line.