This doens't work for me you have just copied and pasted a picture, isn't it ? |
Oh no, don't care about my first message you have just colored the background of cells
good optical illusion :) |
Nope, that is actually a working chart. |
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? |
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. |
>> 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 |
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 .
|
<<Nope, that is actually a working chart.>>
so Google added a feature and kept it at 1.1.4.d? |
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. |
Yup, Tony's right, it was on Digg for today. :-) |
Here it is with explaination.
http://jwelch222.googlepages.com/googChart2.png |
yea so it's actually a trick, not a feature .. btw how to u set the font to be in Webdings? |
Edit in excel copy to speadsheets. |
Nice hack until we have the real charts feature. |
if you look in JavaScript, you will find some functions like "createChart();" ;-) |
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: http://blogs.zoho.com/sheet/publish-charts/ and the Zohosheets home page. http://www.zohosheets.com
Sheets also offers more than 300 prebuilt functions. http://zohosheet.com/functions.do
It's also possible to embed these charts directly into ZohoWriter, Zoho's web-based word processor. http://www.zohowriter.com
Embed info: http://blogs.zoho.com/sheet/publish-charts/ 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: http://blogs.zoho.com/general/sales-presentation-using-zoho-show/ |