its a pain of a workaround 'cause i really need the function to draw its info from another sheet(within the same document)
i found this http://code.google.com/intl/iw-IL/apis/chart/interactive/docs/reference.html#arrowformatter but i have no idea how to use it On 26 ספטמבר, 14:52, ChartMan <[email protected]> wrote: > Reading my mind :-) > On Sep 26, 2011 12:28 PM, "Riccardo Govoni ☢" <[email protected]> wrote:> > Would something like this be good enough? > > https://docs.google.com/spreadsheet/ccc?key=0Av88pFrCTjLhdFhqMVVTZzZJ... > > > I used a combination of spreadsheet functions, unicode characters and > > conditional formatting. > > > First I defined a > > function< > > https://docs.google.com/support/bin/static.py?page=table.cs&topic=25273 > > > > >that, > > depending on the comparison of 2 cells (this week vs last week), > > produces an up arrow or a down arrow: > > > =IF(B2>A2, "⇧", "⇩") > > > For the arrow themselves, I used two unicode arrow > > symbols<http://en.wikipedia.org/wiki/Arrow_(symbol)> > > . > > Last I applied some conditional formatting to the column, specifying that > > the font color should be green if the cell contains an up arrow, and red > > otherwise. > > > -- R. > > > On 26 September 2011 08:35, eric engen <[email protected]> wrote: > > >> i'd rather have it show up in google docs but if their's only a way > >> (and i've noticed that there is a possibility to "publish" said > >> document to the net for free) to do this with an online document that > >> thats just what i'll have to deal with. > > >> thanks again > > >> On 25 ספטמבר, 20:55, ChartMan <[email protected]> wrote: > >> > Do you need this table with arrows to show up in Docs or just in a web > >> page? > > >> > On Sep 25, 2011 4:44 PM, "eric engen" <[email protected]> wrote: > > >> > > hi and thanks in advance to any and everyone who will take the time > to > >> > > answer my question. > > >> > > at the firm i work in we use google docs a lot and i would like to > >> > > have somekind of script or something that will show me a small > up/down > >> > > arrow for different cells by comparing them to a value from last > >> > > week( i have a sheet for every week of the month) > > >> > > if i wasnt clear enough then: last week say my new york shop sold > >> > > 5000$ of goods and this week 3000$ of goods and i want to have a > small > >> > > red arrow indicating that the sale of the new york store has gone > down > >> > > as opposed to last week > > >> > > thank you for any help' im not a programmer but i know my way around > >> > > computers and i believe with just a few small nudges in the right > >> > > direction i will get the results i need > > >> > > -- > >> > > You received this message because you are subscribed to the Google > >> Groups > > >> > "Google Visualization API" group.> To post to this group, send email to > > >> > [email protected].> To unsubscribe from this > >> group, send email to > > >> > [email protected].> For more > >> options, visit this group at > > >> >http://groups.google.com/group/google-visualization-api?hl=en. > > >> > -הסתר טקסט מצוטט- > > >> > -הראה טקסט מצוטט--הסתר טקסט מצוטט- > > >> > -הראה טקסט מצוטט- > > >> -- > >> You received this message because you are subscribed to the Google Groups > >> "Google Visualization API" group. > >> To post to this group, send email to > >> [email protected]. > >> To unsubscribe from this group, send email to > >> [email protected]. > >> For more options, visit this group at > >>http://groups.google.com/group/google-visualization-api?hl=en. > > > -- > > You received this message because you are subscribed to the Google Groups > > "Google Visualization API" group.> To post to this group, send email to > > [email protected].> To unsubscribe from this group, > send email to > > [email protected].> For more options, > visit this group at > > http://groups.google.com/group/google-visualization-api?hl=en. > > > > -הסתר טקסט מצוטט- > > -הראה טקסט מצוטט--הסתר טקסט מצוטט- > > -הראה טקסט מצוטט- -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
