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.
