Perfect thank you Daniel. my graph look excellent and its all because of your support. Thanks Alot https://jsfiddle.net/shahidmajeed/y72yzgsy/7/
On Wednesday, January 20, 2016 at 10:51:11 PM UTC+1, Daniel LaLiberte wrote: > > Currently, you'll need to apply a NumberFormat to each value: > > https://developers.google.com/chart/interactive/docs/reference#numberformatter > > On Wed, Jan 20, 2016 at 4:38 PM, Shahid Majeed <[email protected] > <javascript:>> wrote: > >> I am really appreciate your help, Its look very good. Only one thing is >> left is it possible i can show the number in the form of currency. i have >> tried to set type: "string" to type:"currency" but its show Type >> mismatch. Value 26030 does not match type currency. >> >> >> On Wednesday, January 20, 2016 at 10:32:01 PM UTC+1, Daniel LaLiberte >> wrote: >>> >>> Sorry.. forgot to change the sourceColumn: >>> https://jsfiddle.net/dlaliberte/y72yzgsy/6/ >>> >>> On Wed, Jan 20, 2016 at 4:30 PM, Daniel LaLiberte <[email protected]> >>> wrote: >>> >>>> You need another annotation column for the second series. I made the >>>> change here: https://jsfiddle.net/dlaliberte/y72yzgsy/5/ >>>> >>>> On Wed, Jan 20, 2016 at 4:21 PM, Shahid Majeed <[email protected]> >>>> wrote: >>>> >>>>> I have added the dataview in my jsfiddle >>>>> https://jsfiddle.net/shahidmajeed/y72yzgsy/4/ >>>>> Now i am able to see the sales value for each bar. >>>>> >>>>> But i did not see the avg sales value. >>>>> >>>>> I havent understand the setcolum setting. I think its have to do with >>>>> this setting to show the avg sales value as well on the graph. >>>>> >>>>> could you just check what to do for my avg. sales value. >>>>> >>>>> Thanks alot. >>>>> >>>>> >>>>> On Wednesday, January 20, 2016 at 10:16:27 PM UTC+1, Daniel LaLiberte >>>>> wrote: >>>>>> >>>>>> Sergey mentioned Annotations. You would need to add 'annotation' >>>>>> role columns to your chart. See >>>>>> https://developers.google.com/chart/interactive/docs/roles >>>>>> There is a relevant example here: >>>>>> https://developers.google.com/chart/interactive/docs/gallery/columnchart#labeling-columns >>>>>> >>>>>> On Wed, Jan 20, 2016 at 4:04 PM, Shahid Majeed <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> Hi Daniel, >>>>>>> I have prepare my jsfiddle >>>>>>> https://jsfiddle.net/shahidmajeed/dqxL2Lh2/. what setting i have to >>>>>>> do to sale values in side the bars. >>>>>>> >>>>>>> >>>>>>> On Wednesday, January 20, 2016 at 9:38:47 PM UTC+1, Shahid Majeed >>>>>>> wrote: >>>>>>>> >>>>>>>> Thanks fiddle is working now. But i am trying to produce the graph >>>>>>>> look like attached picture. Only problem is that i dont know how i can >>>>>>>> insert sales values inside bars in the graph. >>>>>>>> >>>>>>>> On Wednesday, January 20, 2016 at 9:26:54 PM UTC+1, Daniel >>>>>>>> LaLiberte wrote: >>>>>>>>> >>>>>>>>> Oops.. sorry, forgot to Save it: >>>>>>>>> https://jsfiddle.net/dlaliberte/vz3byoec/ >>>>>>>>> >>>>>>>>> On Wed, Jan 20, 2016 at 3:25 PM, Shahid Majeed < >>>>>>>>> [email protected]> wrote: >>>>>>>>> >>>>>>>>>> Nothing in jsfiddle. >>>>>>>>>> >>>>>>>>>> On Wednesday, January 20, 2016 at 9:18:42 PM UTC+1, Daniel >>>>>>>>>> LaLiberte wrote: >>>>>>>>>>> >>>>>>>>>>> Looking at your image again, what you really want is what we >>>>>>>>>>> call a 'column' chart. There are several examples on the >>>>>>>>>>> ColumnChart >>>>>>>>>>> documentation page ( >>>>>>>>>>> https://developers.google.com/chart/interactive/docs/gallery/columnchart), >>>>>>>>>>> >>>>>>>>>>> but you can see one running that has two series (like your data) in >>>>>>>>>>> jsfiddle here: https://jsfiddle.net/api/post/library/pure/ >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Wed, Jan 20, 2016 at 3:14 PM, Shahid Majeed < >>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi Daniel, >>>>>>>>>>>> Thanks for your quick response. I am very new to google chart. >>>>>>>>>>>> It would be very helpful if you just give me any sample. I really >>>>>>>>>>>> appreciate your help thanks alot. >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Wednesday, January 20, 2016 at 9:07:45 PM UTC+1, Daniel >>>>>>>>>>>> LaLiberte wrote: >>>>>>>>>>>>> >>>>>>>>>>>>> Hi Shahid, >>>>>>>>>>>>> >>>>>>>>>>>>> The 'bar' package is for the material chart. So use >>>>>>>>>>>>> google.visualization.BarChart instead, and by the way, you can >>>>>>>>>>>>> add the >>>>>>>>>>>>> option theme: 'material' if you want the material colors and >>>>>>>>>>>>> fonts. You >>>>>>>>>>>>> only need to load the 'corechart' package to get BarChart. >>>>>>>>>>>>> >>>>>>>>>>>>> On Wed, Jan 20, 2016 at 3:00 PM, Shahid Majeed < >>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Hi sergey, >>>>>>>>>>>>>> I have change package setting like this >>>>>>>>>>>>>> google.load('visualization', '1', { packages: ['corechart', >>>>>>>>>>>>>> 'bar'] }); >>>>>>>>>>>>>> >>>>>>>>>>>>>> But it does not effect on it. >>>>>>>>>>>>>> Do you have any sample code how i can achieve my requirement. >>>>>>>>>>>>>> >>>>>>>>>>>>>> What exactly i want to acheive is that i have to compare the >>>>>>>>>>>>>> all project leaders. How much they sale and avg sale. As you see >>>>>>>>>>>>>> in my >>>>>>>>>>>>>> picture attached. I have project leaders and their sale and avg >>>>>>>>>>>>>> sale values >>>>>>>>>>>>>> on the graph. >>>>>>>>>>>>>> >>>>>>>>>>>>>> I want to show sale and avg sale values in the bars. so that >>>>>>>>>>>>>> it is visible we dont need to take the mouse curse to see the >>>>>>>>>>>>>> actually >>>>>>>>>>>>>> value. >>>>>>>>>>>>>> second is it possible to show the graph in 3D. >>>>>>>>>>>>>> >>>>>>>>>>>>>> Thanks in advance. >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Wednesday, January 20, 2016 at 7:19:21 PM UTC+1, Sergey >>>>>>>>>>>>>> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hi Shahid, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> It looks like you're using the Material Bar Chart, and are >>>>>>>>>>>>>>> attempting to use annotations. This will not work as lots >>>>>>>>>>>>>>> of options (including annotations) are not yet supported for >>>>>>>>>>>>>>> Material Charts >>>>>>>>>>>>>>> <https://github.com/google/google-visualization-issues/issues/2143>. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Your best bet would probably be to use a Classic Chart (from >>>>>>>>>>>>>>> the >>>>>>>>>>>>>>> 'corechart' package). >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Wed, Jan 20, 2016 at 12:57 PM Shahid Majeed < >>>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>>> I am trying to add sales values inside the bar of the >>>>>>>>>>>>>>>> google bar chart. But did not succeed. Please can someone help >>>>>>>>>>>>>>>> me. I have >>>>>>>>>>>>>>>> following markup. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> <%@ Page Title="" Language="C#" >>>>>>>>>>>>>>>> MasterPageFile="~/Site.master" AutoEventWireup="true" >>>>>>>>>>>>>>>> CodeFile="test.aspx.cs" Inherits="test" %> >>>>>>>>>>>>>>>> <asp:Content ID="Content1" >>>>>>>>>>>>>>>> ContentPlaceHolderID="HeadContent" runat="Server"> >>>>>>>>>>>>>>>> <script type="text/javascript" src=" >>>>>>>>>>>>>>>> https://www.google.com/jsapi";></script> >>>>>>>>>>>>>>>> <script type='text/javascript'> >>>>>>>>>>>>>>>> google.load('visualization', '1', { packages: >>>>>>>>>>>>>>>> ['bar'] }); >>>>>>>>>>>>>>>> google.setOnLoadCallback(drawAntalChart); >>>>>>>>>>>>>>>> function drawAntalChart() { >>>>>>>>>>>>>>>> var data = >>>>>>>>>>>>>>>> google.visualization.arrayToDataTable([ >>>>>>>>>>>>>>>> ['Projektledare', 'Sale', 'Avg Sale'], >>>>>>>>>>>>>>>> ['Wiberg', 26030, 13015], >>>>>>>>>>>>>>>> ['Andersson ', 461690, 19237.08], >>>>>>>>>>>>>>>> ['Ranheimer', 304045, 33782.78]]); >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> var options = { chart: { title: >>>>>>>>>>>>>>>> 'Projektledning: Sales' } }; >>>>>>>>>>>>>>>> var chart = new >>>>>>>>>>>>>>>> google.charts.Bar(document.getElementById('div_chart')); >>>>>>>>>>>>>>>> chart.draw(data, >>>>>>>>>>>>>>>> options); >>>>>>>>>>>>>>>> } </script> >>>>>>>>>>>>>>>> </asp:Content> >>>>>>>>>>>>>>>> <asp:Content ID="Content2" >>>>>>>>>>>>>>>> ContentPlaceHolderID="MainContent" runat="Server"> >>>>>>>>>>>>>>>> <div id="div_chart" style="height: 400px; text-align: >>>>>>>>>>>>>>>> left;"></div> >>>>>>>>>>>>>>>> </asp:Content> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Picture attached how the graph look. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Thanks in advance >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>> https://groups.google.com/group/google-visualization-api. >>>>>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>>>>> https://groups.google.com/d/msgid/google-visualization-api/5d68bf0e-eb70-46ab-8ff1-823b1663e48a%40googlegroups.com >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> <https://groups.google.com/d/msgid/google-visualization-api/5d68bf0e-eb70-46ab-8ff1-823b1663e48a%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>>>>> . >>>>>>>>>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> *[image: unnamed.gif]• Sergey Grabkovsky• Software Engineer• >>>>>>>>>>>>>>> Google, Inc• [email protected]* >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>> 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 >>>>>>>>>>>>>> https://groups.google.com/group/google-visualization-api. >>>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>>> https://groups.google.com/d/msgid/google-visualization-api/6c052bbc-47a9-4231-91f2-89a0b54334b5%40googlegroups.com >>>>>>>>>>>>>> >>>>>>>>>>>>>> <https://groups.google.com/d/msgid/google-visualization-api/6c052bbc-47a9-4231-91f2-89a0b54334b5%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>>> . >>>>>>>>>>>>>> >>>>>>>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> Daniel LaLiberte >>>>>>>>>>>>> <https://plus.google.com/100631381223468223275?prsrc=2> >>>>>>>>>>>>> [email protected] 5CC, Cambridge MA >>>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> 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 >>>>>>>>>>>> https://groups.google.com/group/google-visualization-api. >>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>> https://groups.google.com/d/msgid/google-visualization-api/44991f0a-5026-4882-87a7-df3b210b8788%40googlegroups.com >>>>>>>>>>>> >>>>>>>>>>>> <https://groups.google.com/d/msgid/google-visualization-api/44991f0a-5026-4882-87a7-df3b210b8788%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>> . >>>>>>>>>>>> >>>>>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> Daniel LaLiberte >>>>>>>>>>> <https://plus.google.com/100631381223468223275?prsrc=2> >>>>>>>>>>> [email protected] 5CC, Cambridge MA >>>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> 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 >>>>>>>>>> https://groups.google.com/group/google-visualization-api. >>>>>>>>>> To view this discussion on the web visit >>>>>>>>>> https://groups.google.com/d/msgid/google-visualization-api/e3c451e8-26d8-4701-98d3-247ed23ea2d0%40googlegroups.com >>>>>>>>>> >>>>>>>>>> <https://groups.google.com/d/msgid/google-visualization-api/e3c451e8-26d8-4701-98d3-247ed23ea2d0%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>> . >>>>>>>>>> >>>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Daniel LaLiberte >>>>>>>>> <https://plus.google.com/100631381223468223275?prsrc=2> >>>>>>>>> [email protected] 5CC, Cambridge MA >>>>>>>>> >>>>>>>> -- >>>>>>> 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 >>>>>>> https://groups.google.com/group/google-visualization-api. >>>>>>> To view this discussion on the web visit >>>>>>> https://groups.google.com/d/msgid/google-visualization-api/cbd34695-5b66-4adf-bf0b-b7edab92e654%40googlegroups.com >>>>>>> >>>>>>> <https://groups.google.com/d/msgid/google-visualization-api/cbd34695-5b66-4adf-bf0b-b7edab92e654%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Daniel LaLiberte >>>>>> <https://plus.google.com/100631381223468223275?prsrc=2> >>>>>> [email protected] 5CC, Cambridge MA >>>>>> >>>>> -- >>>>> 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 >>>>> https://groups.google.com/group/google-visualization-api. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/google-visualization-api/74b1ffed-2d3b-4552-93de-d337e5ad329d%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/google-visualization-api/74b1ffed-2d3b-4552-93de-d337e5ad329d%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> >>>> >>>> -- >>>> Daniel LaLiberte >>>> <https://plus.google.com/100631381223468223275?prsrc=2> >>>> [email protected] 5CC, Cambridge MA >>>> >>> >>> >>> >>> -- >>> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >>> [email protected] 5CC, Cambridge MA >>> >> -- >> 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] >> <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at >> https://groups.google.com/group/google-visualization-api. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/google-visualization-api/704aa4c1-08b0-4f0c-a4a9-c447c27061ac%40googlegroups.com >> >> <https://groups.google.com/d/msgid/google-visualization-api/704aa4c1-08b0-4f0c-a4a9-c447c27061ac%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> > [email protected] <javascript:> 5CC, Cambridge MA > -- 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 https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/98da487f-fc07-4b77-b589-c37c6588bb7b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
