Re: OT - Charts

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 15 Nov 2012 13:04:19 +0000
Message-ID: <CABe10sb+PJGkOHgQXQsCUXbjHAMbCbk9DFCkiy9VahrfcYTTCQ_at_mail.gmail.com>



Thanks
I also asked the SQL*Server lead here and the answer in Excel is (as it often is apparently) "Use a Pivot Table" Specifically generate a pivot table and use Date as row labels, Tablespace as column labels and "sum of" size as the values. Choose a stacked area chart to plot.

It occurs to me that APEX might well work as well.

On Thu, Nov 15, 2012 at 11:01 AM, Lanray <larryklean_at_yahoo.com> wrote:

> Hello Niall
>
> I think crystal report might be your best option.
>
> On Nov 15, 2012, at 4:40 AM, Niall Litchfield <niall.litchfield_at_gmail.com>
> wrote:
>
> > I guess I'm really looking for excel or similar help..
> > I have a set of tablespace data along the lines of the table below
> >
> >
> > Date Name Size March TS1 100 March TS2 200 March TS3 300 April TS1
> 120
> > April TS2 200 April TS3 350 May TS1 150 May TS2 200 May TS3 400 June
> > TS1 190 June TS2 200 June TS3 450
> > I'd really like to present this data like this graph
> >
> >
> http://en.wikipedia.org/wiki/File:Operating_systems_used_on_top_500_supercomputers.svg
> >
> > ie showing change in share over time, but I can't seem to find the right
> > magic incantation in excel to do this. If anyone has done something
> similar
> > and can share I'd be grateful.
> > --
> > Niall Litchfield
> > Oracle DBA
> > http://www.orawin.info
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 15 2012 - 14:04:19 CET

Original text of this message