View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default custom chart... please help!

It's possible to have a column and xy scatter but...

I think we would need to see some sample data and an explanation of what the
desired results would be for that sample.
--
Cheers,
Shane Devenshire


"Leslie" wrote:

I have a lot of data I need to process. Many different categories. What I'd
like to do is have some hybrid of a column chart and xy scatter chart... X
axis=location, Y axis=result, and at each location have several "criteria"
such as A,B,orC. However, I'd like to actually see a marker for each data
point so I can see outliers and where the majority of the data lies. The raw
data is in columns and not sorted. Tried pivot table with no success. I have
conquered some VBA and programming in the past and wouldn't object to that
approach with some guidance. Please help!
Thanks,
Leslie