I will try and see if I can get it to work as suggested...however I don't
hold much hope as I am using Beta 2 TR....and no this is not real work but it
is an offline copy of a real workbook used for data analysis to try and get a
feel for what effects the new version of office may have on my users.

The problem with formula-generated dates was an old one, fixed by
Beta 2 or the Beta 2 Refresh.

I am using the B2TR for testing and if this is an old problem its still not
gone yet. I can provide a non confidential version of the workbook or the
formulas themselves if you would like.

"Jon Peltier" wrote:

1. I hope this isn't real work you're having trouble with, but it sounds
like you've disregarded all the warnings about using a Beta for important
stuff. The Excel Beta is not really ready for production charting. The
dialogs are immature and inefficient, and some things just aren't quite
working. The problem with formula-generated dates was an old one, fixed by
Beta 2 or the Beta 2 Refresh.

2. The built-in custom types have always been somewhat limiting, You're
better off creating your own custom types. Create the type with all three
series as columns, then select one series, and using whatever mechanism
(chart menu chart type in Excel 97-2003 or chart type on one of the chart
context tabs on the ribbon in Excel 2007) change the series to a line type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Cosmic" wrote in message
...
I'm having issues with the chart options. I'm trying out the chart type
that
contained two columns and a line all on the same graph. I have two issues
with this

First it appears that Microsoft has removed this type of chart as an
option
all together (used to be under chart wizard - Custom Types (tab) -
Line -
Column).

Secondly the file that I currently have with this chart type no longer
displays properly. By this I mean that the x axis categories are dates
which
are pulled using a formula. Excel however refuses to format these
categories
as dates. I can format them as any and everything else but if I try to
format them as dates the text simply disappears and I no longer have x
axis
categories.

If anyone can help me with either of these issues I would greatly
appreciate
it as my company extensively uses this type of chart to analys production
data.