lets say 1 have a worksheet and the values are as a sampl
15           3          
23           6          
I want to plot a chart that has a point at 3,5 (x,y) labeled 15, and another point at 6,9 labelled 23 what chart do I us

Hello All, Anyone an idea how to construct such a chart in Excel?
http://chart.yahoo.com/c/5y/p/pdli.gif
I know you can build more then one chart into one chart sheet but what
i really want to do is construct one chart or 2 chart objects

I am trying to create a chart that may have a max of 50
rows of data, but usually has only 30 rows of data.  Is
there a way to build the chart so that if additional info
is entered (up to 50 rows) it will all be charted, but

Can someone tell me if this is possible.  I want to be able to create a
chart that represents a week.  There will be seven bars and each bar will
represent the day my business is open.  I want to be able to enter starting
times in one column, let's say column B and a quitting times ...

Does anyone know to set the maximum Y-Axis value by using VB6.0
remarks
the chart automatically create on excel sheet by using Vb 6.
thanx in advance

Can anyone tell me, how can a file size be reduced.

How do I add documentation/desriptions for VBA functions or function
variables?
I have tried to add a description to a function's properties under its
Memeber Options in VBA but the description is not displayed when the

I'm comparing the sugar content of different beverages.
However the values vary for example cocktails may have
between 90-130 grams per liter and vegetable juices
perhaps 40-100 grams. Which type of graph should I use to

H
I am looking to create a chart that will show some weekly stats. The first week involves current vacancies as at 21 Jan, 2004
The fields are
                                           Advertised Internal |      Advertised External   |        Tota

I am working with an excel based program that is in Excel 97 format.
Upon opening the program in 2000 it does prompt me with the warning
that there are macro compatibility issues.
I have developed a macro in Excel 2000 to use data to create a chart

Let's say I have a chart in a chartsheet.
I'll like a visual aid to be able to direct, say, a discussion's focus
from one point on the chart to another.
Is there a way to put something like a "movable"

I'm using Excel 2000.  I'm trying to make a bar chart, but if I selec
any of the bar chart types, they all appear pencil thin (as just
line).  If I select the data series and try to go to Format / Options
the Overlap says its 100 and the Gap Width says its 150.   Changin

Hello --
This chart will plot data imported from one or more text files.
We want 2 buttons on a UserForm which will allow the user to
1 - erase the old chart and build a new chart "structure"

I am trying to plot some data on a line graph, and the data for th
x-axis has a starting value of zero.  I want the data to be plotted s
that the first value is plotted right on the y-axis itself.  Instead
Excel moves it over to the left, and adds an extra number to the

Help! Excel Charts losing formats
I am using Excel 2000 SP-3 on a Windows 2000 machine and have bee
having some strange problems. I have 4 charts that are in a singl
workbook along with the source data for them. After the workbook ha