Google Blogoscoped

Forum

Google Spreadsheets with Charts

John Welch [PersonRank 3]

Friday, August 11, 2006
13 years ago3,859 views


jwelch222.googlepages.com/goog ...

TOMHTML [PersonRank 10]

13 years ago #

This doens't work for me
you have just copied and pasted a picture, isn't it ?

TOMHTML [PersonRank 10]

13 years ago #

Oh no, don't care about my first message
you have just colored the background of cells

good optical illusion :)

John Welch [PersonRank 3]

13 years ago #

Nope, that is actually a working chart.

Tony Ruscoe [PersonRank 10]

13 years ago #

Why would all the even numbers be missing from the Y axis except for number 8? it doesn't make sense.

Where is the data for the graph?

Are you willing to share the spreadsheet or post screenshots of the UI showing the setup options?

John Welch [PersonRank 3]

13 years ago #

Yes, if you want to see how it works put your email here. I'll invite anyone that wants see it.

The data for the graph is in Column F.

(I wanted just the odd numbers displaying for each record and I forgot to delete the 8)

I updated the spreadsheet so you can see the column when editing. Also, it does not display correctly in FireFox, you must have IE and have Webdings installed.

TOMHTML [PersonRank 10]

13 years ago #

>> Nope, that is actually a working chart.
ha ha ha...

Tony, look the width of the columns and compare them with the width of the elements of the "chart" ;-)
however, I don't know wich character, colored in blue, is used for the blue lines

/pd [PersonRank 10]

13 years ago #

John, could you snap a shoot of the menu item that permits you to generate a chart ?? that is, the traditional method of specifying the X and Y axis ??

just crop the screen and post back here pls .

Mrrix32 [PersonRank 10]

13 years ago #

<<Nope, that is actually a working chart.>>

so Google added a feature and kept it at 1.1.4.d?

Tony Ruscoe [PersonRank 10]

13 years ago #

I get it now. It's a working chart but it wasn't created by Google Spreadsheets, although it does use actual data to draw it.

I was looking at a tutorial just today explaining how to do something similar in Excel.

John Welch [PersonRank 3]

13 years ago #

Yup, Tony's right, it was on Digg for today. :-)

John Welch [PersonRank 3]

13 years ago #

Here it is with explaination.


jwelch222.googlepages.com/goog ...

Ramibotros [PersonRank 10]

13 years ago #

yea so it's actually a trick, not a feature ..
btw how to u set the font to be in Webdings?

John Welch [PersonRank 3]

13 years ago #

Edit in excel copy to speadsheets.

Philipp Lenssen [PersonRank 10]

13 years ago #

Nice hack until we have the real charts feature.

TOMHTML [PersonRank 10]

13 years ago #

if you look in JavaScript, you will find some functions like "createChart();" ;-)

Gary Price [PersonRank 10]

13 years ago #

Just a note to point out that Zoho Sheet has offered a ton of charts (via spreadsheets) since June (pre Google Sheet). These include Draw bar/line/pie 2D/3D charts. See:
blogs.zoho.com/sheet/publish-c ...
and the Zohosheets home page.
zohosheets.com

Sheets also offers more than 300 prebuilt functions.
zohosheet.com/functions.do

It's also possible to embed these charts directly into ZohoWriter, Zoho's web-based word processor. zohowriter.com

Embed info:
blogs.zoho.com/sheet/publish-c ...
  
Cool!

and while I'm on the subject of Zoho, check out what you can know do using OLE to create an entire presentation (some might call it PowerPoint like) using various Zoho services (all free). See this post:
blogs.zoho.com/general/sales-p ...

This thread is locked as it's old... but you can create a new thread in the forum. 

Forum home

Advertisement

 
Blog  |  Forum     more >> Archive | Feed | Google's blogs | About
Advertisement

 

This site unofficially covers Google™ and more with some rights reserved. Join our forum!