I am trying to create a chart using nonadjacent selections and the chart
wizard does not seem to be representing the data in a way I can
understand.  It has worked fine for two previous charts - producing a
column chart showing a comparison between two sets of figures across a

I need a chart that has both a vertical bar graph and a
line connecting points.  I've been unable to figure out
how to do this from the chart options, as there are
options for vertical bar graphs, and options for line

Windows 2000
Office 2000
I have a chart with the data table showing.  The values go into the millions.  On
the axis, I'd like to use e.g. $1M instead of $1,000,000.  Is there a way that I

I am trying to graph the following data (example)
12.1   1
13.1   1
14.1   1

How can I include maps for US Virgin Islands and Guam with
the US map when I chart data from Excel?  I am using Excel
2000.  
I understand that MS Map is not supported in later

Excel 2000 locks up when i click on chart wizard when I
am in a new blank workbook or a workbook that contains
numbers.  It closes and wants to send error report to
microsoft.  I have renamed mso9.dll and reinstalled

I am just wondering how to display a excel chart into a form.
I was able to call my chart object in the VBA code as:
Dim temp As ChartObject
Set temp = Worksheets("ChartDisplay").ChartObjects(1)..

I have copied the voting information from Outlook and I
want to graph the responses in Excel. I know it can be
done with a pivot chart, but that is beyond my users
abilities. The data looks like this

When I "hide" the reference cells by making their row
height 0.00, the chart blanks out.  Is there any other
way to do this without making the chart go blank?  Why
would this make the chart go blank to begin with?

Is is possible to not chart blank formula values as zeros.  I have tried using tools, options, and chart (plot empty cells as 'not plotted').  This does not seem to work when the cell is referencing a formula.  Thanks!

I have created a multiple sheet Excel workbook, with
about 15 pages of charts and tables.  The problem is that
when I print them (whether to a printer, or a print
preview), some of the objects move around.  

my data basis for a chart has one column,
that I don't want to be shown in the spreadsheet.
However, when I set this column's width to zero,
the correspondig data dissapear from the chart.

Trying to chart a series of date ranges (sort of in a timeline-typ
fashion).  Chart keeps showing beginning and end dates as two separat
bars.  I need them to span the entire year showing what amount of tim
they take up.

How do I use a List Box, with the months in it, allowing
the user to click on a month and pull up that particular
chart?  Do I have to create several charts and use the
list box as a hyperlink or can I have the chart create

I'm using a procedure Harold Staff made for me a few years ago. It works
very well, but I would like to improve on it slightly, but I don't know
how, or if it's even possible. I'm using XL2002 and Windows XP.
I made one change to remove the border, now I would like to export the