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
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-lReceived on Thu Nov 15 2012 - 13:53:12 CET