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=0Av88pFrCTjLhdFhqMVVTZzZJdWYtT0lYTTV3elpseEE&hl=en_GB > > 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.
