View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Cosmic Cosmic is offline
external usenet poster
 
Posts: 6
Default excel 2007 Beta-Charting

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.