Hi, I'm not really sure what you're trying to do, but I'm not entirely convinced that you need two axes. It seems like your data is roughly of the same scale (in fact, I would assume that Avg Sale is derived from Sale), so the chart should just look fine without a secondary axis.
On Wed, Apr 1, 2015 at 4:24 PM Shahid Majeed <[email protected]> wrote: > Hi, > I am new to google chart api. I am trying to create a bar chart with Sale > and Avg sale series. I Succeed to create chart but i tried allot to set the > Y-axis steps to make the chart sensible. > > If you check my chart left Y-axis (Sale) range from 0 to 800K and right > Y-axis(Avg) range from 0 to150K. > Most of the columns shows the average column higher than sale because its > draw according to value. > > Any suggestion please how to make this sensible. > > Thanks in advance > > Here is my script > <script type='text/javascript'> > google.load('visualization', '1', {packages: ['bar' > ]}); > google.setOnLoadCallback(drawSaleChart); > > function drawSaleChart() { > var data = google.visualization.arrayToDataTable([ > ['Projektledare','Sale','Avg'],['Anstenius',53575, > 13393.75],['Björnaes',147395,13399.55],['Hammarstrom ',80810,26936.67],[ > 'Fuglsang',112080,56040],['Wilsletf',779635,41033.42],['Ranheimer',287151, > 143575.5]]); var options = {chart: { title: 'Projektledning: Sales'}, > series: { > 0: { axis: 'Sale' }, > 1: { axis: 'Avg' } > },axes: { > y: { > Sale: {label: 'Sale'}, > Avg: {side: 'right', label: 'Avg > Sale'} > } > }};var chart = new google.charts.Bar > (document.getElementById('div_chart'));chart.draw(data, options);} > </script> > <div id="div_chart" style="height: 325px; text > -align: left;"></div> > > > > Here how the chart look like > > <http://i57.tinypic.com/16gfjhs.jpg> > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
