How can I specify on the same chart which fields I want to be displayed as
Column and which fields I want to be displayed as Line?  I have over seven
fields.  Let's say I want columns B through E to be columns and the other
columns to be lines.  Thanks in advance.

When I run the macro shown below on a worksheet with columns of data (with
column headings in row 1) I get some unusual results in Excel 2007 Beta 2
(different from Excel 97-2003).  In Excel 97-2003, the Chart has 0 series
before SeriesCollection.Add and 1 Series after ...

Line graph for actual goal from January through August--the line graph for
Sept-Dec follows the formula for August.  I would like the line graph to stop
at August--and only appear as I put the actual date in for each month.  Can
this be done??????

I've got a series of data on a line graph. It's nothing too rancy - dates and
rates.
3/1/2006    4.660
3/3/2006    4.710

I need to insert a 'dynamic' vertical line into a line-chart -- the
line will separate the Past from the Future.  After some searching, I
found Jon Peltier's site, which had some really good information on it
..... but I just can't get it work!

My titles show up in the "Chart Options" menu.  they are in black font on a
grey background.  They simple do not appear on my chart itself.  I finally
found my title block and it is MICRO in size, i can't even grab the handles
to make it larger, only move it around.  my axis ...

Hi, I have a column diagram. The data labels are shown just below the X-axis
for negative values.
The problem is that when columns goes below x-axis they go across the data
labels. How can I move to make the labels go above columns if positive values

I can't figure out how to plot the function as a graph? Where do I go? Charts
seem to only work with data.

I have 6 categories which I am collecting monthly data on.  I have a goal for
each.
I would like to create a bar/thermometer chart for each category, showing
monthly progression and show the goal at the top.  Can I do this through a

Hi can anyone help with these two questions.
Windows 2000.  Office 2002.
Chart in Excel
Question 1.

i have tried a few ways to alter the scale on the x axis of a scatter
graph but so far not found a way to do it as i would like.
my data point are at:   2  4  8  16  32 64 etc
i want the axis to start at 2 but have major markers at 8 16 24 32 etc

I am an audiologist working for a London hospital and am interested in trying
to computerise some of the analyses of tests we currently work out by hand.
One test involves playing speech at different intensity levels and then
plotting the patients performance as a series of ...

I want to do a comparion report for different vendors we are considering.
Basically, there are four vendors and twenty-five criteria (cells) for each
vendor. Any help would be appreciated!

How do I insert autodates into an Excel Spreadsheet?

In a workbook with multiple charts on multiple spreadsheets, the chart option
to add a trendline is available on some of the charts and not on others -
why?  (I have tried right clicking on the series - that is not the problem).  
The data on the underlying spreadsheet appears to ...