Prev: How do I set up a 3 on 3 basketball tournament bracket with 64 tea
Next: How to convert MKV to AVI, MOV, FLV, PS3 and MP4 on MAC with iFunia MKV converter
From: babs on 24 Mar 2010 23:36
I agree with you but for some reason they want to visually show the BAr for
each value with the x being time (not category) - seems like you should be
able to do this????? - is there really no way ?
Thanks,
barb


"David Biddulph" wrote:

> You are missing the fact that the X axis on a column chart is a list of
> categories, not values. You are right that if you want values you should
> use XY.
> --
> David Biddulph
>
>
> "babs" <babs(a)discussions.microsoft.com> wrote in message
> news:08413639-F955-43EB-9145-4590B89E5CD7(a)microsoft.com...
> > I have had 2 requests in the past two weeks from quality dept. on how to
> > chart data with the x axis time in Hrs and the Y being some measurement
> > result(ie. roll hardness, #particles)
> > I know we can do this with the XY- Scatter chart but both groups want to
> > use
> > the Column chart -
> > The X-axis just looks at the HRS and puts them same distance with each
> > other
> > no matter what the value is-
> >
> > I can't believe there is not a way around this to make the column chart X
> > axis(independent axis) to be spaced based on the ACTUAL values
> >
> > What am I missing???
> >
> > Thanks,
> > Barb
>
>
> .
>
From: Herbert Seidenberg on 25 Mar 2010 14:26
Excel 2007 Tables, Charts
Bar chart with continuous XY time values.
Two examples:
http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_24_10.xlsx
http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_24_10.xlsm
Pdf preview:
http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_24_10a.pdf
http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_24_10b.pdf
 | 
Pages: 1
Prev: How do I set up a 3 on 3 basketball tournament bracket with 64 tea
Next: How to convert MKV to AVI, MOV, FLV, PS3 and MP4 on MAC with iFunia MKV converter