Re: OT - Charts

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 15 Nov 2012 07:53:12 -0500
Message-ID: <CAGurbTMbWVO-kUbS1ozcxc52iu9inNVL5zWRDxWVoMM5J28pjA_at_mail.gmail.com>



'100% stacked area' ? in excel 2007, and you provbably want to reformat your data as below which will make it easier.  Date TS1 Size TS2 Size TS3 Size March 100 200 300 April 120 200 350 May 150 200 400 June 190 200 450
Or use html with Google Visualization

<html>
  <head>
    <script type="text/javascript" src="https://www.google.com/jsapi
"></script>

    <script type="text/javascript">

      google.load("visualization", "1", {packages:["corechart"]});
      google.setOnLoadCallback(drawChart);
      function drawChart() {
        var data = google.visualization.arrayToDataTable([
          ['Month', 'TS1 size', 'TS2 Size', 'TS3 Size'],
          ['March', 100 ,200, 300],['April', 120,200,350 ],['May',
150,200,400 ], ['June', 190, 200, 450 ] ]);

        var options = {title: 'Tablespace Usage', isStacked: true, hAxis: {title: 'Month'}};

        var chart = new
google.visualization.AreaChart(document.getElementById('chart_div'));

        chart.draw(data, options);}
    </script>
  </head>
  <body>
    <div id="chart_div" style="width: 900px; height: 500px;"></div>   </body>
</html>

Raj

On Thu, 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
>
>
>


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 15 2012 - 13:53:12 CET

Original text of this message