If the input data are in a separate sheet of the same Google document, then you can still use the same logic. The function just changes to reference a different sheet:
=IF(Sheet1!B2>Sheet1!A2, "⇧", "⇩") I have updated the document to contain the same arrows in Sheet2, referencing the contents of Sheet1. Or am I missing something? The ArrowFormatter you found is useful if you accept to put your data inside a Table<http://code.google.com/apis/chart/interactive/docs/gallery/table.html>visualization and host the visualization in a webpage, separate from your spreadsheet (I don't think there's a way to use formatters when embedding visualizations as gadgets inside a spreadsheet, unless you're willing to roll out some code of your own to do so). -- R. On 26 September 2011 13:00, eric engen <[email protected]> wrote: > 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. > > -- 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.
