I am using Excel 2002.
I have an excel worksheet that has four charts.  All four charts ar
being greyed out.  I don't know how and why.  But when I click on on
of them, the one being clicked on will be viewable, but the other thre

Hello --
This charting application has the following features:
1 - user can "import" a time series (into a set of columns in a worksheet);
the app automatically adds a plot of the data to the chart

I am trying work out a way in which to get pie chart segments to sho
one of three colours based upon set percentage conditions on the hos
worksheet for each segment value
--

Hi  - I have calculated some normal distriubtions results for a number of numbers in a sample.. (Using the normdist function).. How do I then go about charting this distribution?? or is there another way of charting a distribution without using the normdist function.. Any help ...

I have a line graph set up with 20 rows of data.  Sometimes several o
the rows have no data but they still have a representation on the grap
legend as the data series includes this.
Is there any way that I can only show legend entries for rows with dat

I want to use a stacked area chart, but some of my data (intentionally) uses negative numbers.  These display in okay in most area charts, EXCEPT stacked.  In the stacked version the negative numbers are displayed as positive
This seems like a bug to me
Anyone know a way around ...

I currently have a series of lines plotted on an XY scatter chart.  
have check boxes setup in the data so that I can display any or all o
the lines at any given time.  The legend always displays every singl
series, regardless if it is visible on the chart or not.  I woul

I created some charts with multiple data series by specifying certain points on the curves. THe series are displayed as lines. Now I want to draw (or specify the Y coordinates of) a horizontal line on the chart, & have Excel tell me the X intercepts where the horizontal line ...

What I'd like to have, is a system so that users can specify a .CSV t
get some data from.
Currently, my macro only will generate a Pie Chart from a variabl
range of values, but as the data will come from a .csv file, i'd lik

do Excel, Access, Word and Powerpoint all use MSGraph.Chart.8?
Is only Excel using MSGraph as inproc server (because no graph.exe process
is started)
or is the component Excel-embedded?

I am new to vb.  So please bear with me.  I thought that I could jus
change the type of chart to plot and excel would comply.  What did I d
wrong and how can I fix it?
With WS.ChartObjects.Add _

I have a list of points in an excel file that is as follows:
0.195062    -1.429289
0.195062    -1.429289
0.219444    -1.437452

I am plotting a XY chart.I cannot use data labels to distinguish the different points as it is gets messy when there are too many points close by
Can we have a tool tip kind of thing for identification. Like when we put the cursor on the point, it gives a tip of Series 1..., in a ...

How can I return the last number in a column when the column is expanding
(being added to each day)?
Thanks.

The order of the worksheets is:
MainMenu
   Its Worksheet_Activate() event says
   frmMenuMain.Show