Re: OT - Charts

From: Robert Hanuschke <robert.hanuschke_at_gmail.com>
Date: Mon, 19 Nov 2012 16:38:04 +0100
Message-ID: <CAL6WDh01wwaKKKOhg=R-jBPo6TWHe5qEQHOrbA-A_wFWQ=Ghnw_at_mail.gmail.com>

Hi Niall,
if you're into Perl and possibly have to generate that graph more often - in the best case getting the data from a automatically readable source - then GD::Graph is a module to look at.

http://gdgraph.com/samples/sample23.html (if your values always sum up to the same total for any given point in time, the graph will look like the one you linked)

I use it regularly to visualize important trends.

Best regards,
Robert

On Thu, Nov 15, 2012 at 2:04 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 19 2012 - 16:38:04 CET