I want plot many lines on one graph so that comparison is
easy? PLease help.

I have data in a tabular format (RxC), created by a macro, not a pivot
table. I want to be able to create a dynamic chart linked to the data as ff:
1). I will have a drop down combo box with a list of all the available
columns

I have a pivot table showing various figures with a grand
total column at the right hand side, automatically
generated by selecting grand totals for columns under
pivot table options.  

is there a way in MS-Graph to switch to a hyperbolic Scale? Yet, I only know
about the "normal" and "logarithmic" scales.
Thank you! And ...please excuse my bad English... Axel

Does anyone know if it is possible to make a 3-D scatter plot using excel?  Or do you know of a free program that will do it if excel won't
Thanks

How to correlate two or three charts in a sheet.

I have 10 worksheets per workbook. Each worksheet has the same parameters of which I would like to trend. However due to the dates in each worksheet differing (and non consecutive), the chart accepts the dates of the first worksheet as the x-axis and plots all subsequent ...

I wish to plot two text categories against each other using Excel, on
of the categories is technically a number but are number range
exported from Access i.e. "0-30", 31-60" etc
I have peoples names on the X axis and I wish to plot physical activit

How could I size chart's plot areas equally, height and
width? Both charts have different series and categories.
- thanks.

It did not work. There may be some trick with it but I
couldn't find it either.
OK let me explain a bit more.
Category data is one year date, yet, it is not 365 days.

Hi
Can anybody advise me on how to name a chart in VBA,
rather than let excel do it.
Are there any sites that have good details on dealing with

I have built a simple line graph, showing last year sale figures, this
years budget and this years actuals. I have 12 months worth of data for
the first two categories, but only two months for actuals.
The problem I have is that the data for the graph is being taken from a

How can I adjust the following macro to make the MinimumScale value and
MaximumScale value dynamic (by referencing a cell in one of my spreadsheets)
instead of fixed (currently 5400 and 7000)
Sub Macro2()

I would like to know a way to insert the "Current Date" into the upper right
hand corner of an Excel Chart Area. I know this can be done in MS Access Is
there a way to do it in Excel?
Thanks,

I have a picture of a line chart pasted into a word document which wa
originally created in excel. Unfortunately I have lost the underlyin
data that was used to create the chart. Is there any method that anyon
knows of taking the picture of the chart I have in the word documen