Tracker


		Advanced Search

HOME

TRACKER

Flash

Excel Graph

How do i make a bar chart or pie chart or graph in 2004 using an Excel sheet.Seen it done at demonstration, but forgot.Please help.

KirupaForum > Flash > Flash 8 (and earlier) > Flash MX 2004
Posted on: 05-19-2004, 08:48 PM

View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread

Excel Graph
How do i make a bar chart or pie chart or graph in 2004 using an Excel sheet.
Seen it done at demonstration, but forgot.
Please help.

Excel Vs PDF
I want the viewer to be able to click on a button and have a screen full of data originally created in an XL spreadsheet appear so that viewer can print the screen. I just assumed that putting this spreadsheet into a pdf format would be the way to go. But I can not import a pdf file. Yet I have seen pdf files displayed in flash created web pages. How do I do that? Or can I drop the XL file into a frame, create an MC, and solve the problem that way?

I appreciate any suggestions.

From Excel To AS
I tried and tried to pass some calculations from excel to AS (I USE FLASH 8) BUT NO WAY TO DO IT, I feel so so stupid . Any help, please!?

Attached to this post is the excel compressed in a zip file

Thanks in advance for any help or charity...!!! lol

MS Excel To XML
--Just posted this in another thread, then thought that since AS3 makes it so easy to use XML why not here as well?--

Hey everyone. I just wanted to share some knowledge that I learned in the past few days that I think may help many others in their quest for a quick simple solution for exporting a Microsoft Excel document to XML.

I was tasked with creating an HTML page that had to display a Microsoft excel document with some 4,500 entries. My boss also wanted it to be XML for quick and easy changes/updates/etc.. There was no way I was going to sit down, and hand code some 12,500 lines of code and spell check it by Friday.

So I figured out how to export the Excel document into XML. and boy did it save me time. I scoured the internet for hours and found little documentation on this, and Microsoft Help was not that explicit in their explanation.

******************This is for Microsoft Excel 2003******************

So Here is my mini tutorial:

1. create an XML schema to be used as a map inside Microsoft Excel
Ex:
HTML Code:
<?xml version="1.0" encoding="ISO-8859-1"?>

<CATALOG>
<USER>
<ID></ID>
<COUNTRY></COUNTRY>
</USER>
<USER>
<ID></ID>
<COUNTRY></COUNTRY>
</USER>
</CATALOG>
Once you have your map saved, and named logically such as "myexceldocumentname"_map.xml you are ready to open up Excel.

Once inside Excel open up your spreadsheet that you want converted to XML for use to display in HTML.

1.Click Data/XML/XML Source from the menu
2. The XML Source window should open. Click XML Maps on the bottom
3. Navigate to the .xml file we created and saved earlier
4. Click OK OK OK to get out of the prompt and back to your document.
5. Inside the XML source window you will now see a schema/tree diagram of the .xml document we created earlier.
6. Click and drag the corresponding tags to the correct column/row that has the info associated with it.
7. Click Data/XML/Export
8. You should now have an .xml document with the correct values inside of the tags that corresponds with your Microsoft excel document.

I later had to Style the .xml with .xsl to display in a web browser, but .xsl is a beast in and of itself.

Cheers!

I just tried to replicate this and ran into an error, that was quickly resolved. The error did not allow me to import the schema. To avoid this, make sure your schema is wrapped all inside 1 tag.
You can later delete this open/close tag if needed.

Graph Help
hi

how can i create a line graph according to x,y coordinates??

thanks in advance

Bar Graph Help
I am pretty basic at my flash skills. (to me it's basically a vector powerpoint).

Anyway, I am needing to make an interactive graph where someone can enter a number 1-70 and have a bar show up representing that number.

I will need to have multiple bars in different colors and in multiple sections.

something like this...

I am using Flash CS3 Pro. Thank you for your help.

Graph
Hi,

I am trying to build a graph that will load from an external data source and I have a couple of questions.

How do I measure the length of a string so I can right align the axis labels?

How do I figure out the size of the flash object? If I put a:

var s:MovieClip = this.createEmptyMovieClip("text1", 2);

It seems to change my _root._width In the commercial flash graphs you can set the size of the graph using variables. I would like to be able to do this also.

Is there any way of doing matrix stuff so I can transform my graph co-ordinates so X goes up from the bottom?

If there are any tutorials on how to do this I'd be ever so grateful!!

Many thanks.

monk.e.boy

Graph Help
hi all

i have a graph file
in that there are 12 points but it shows only 10 red balls and not 12 red balls

pls find the attached file

Graph.
Dear All,

needs help badly to teach me how to do code this dynamic graph, if you guys have any ideal how to do code this please teach me ~~
thanks alot.

Firstly, the graph has a normal X and Y axis.

The though part is this:
Whenever the mouse cursor moves inside the graph, there must be "tracing lines" shown together with the corresponding coordinates (that is the coordinates at the position of the Mouse Over). Tracing marks meaning:
something like this this.
If the mouse cursor points over for example pointA(4, 6), a horizontal line will be join from the position of the mouse to the value of the y-axis that is 6 in the case of pointA and then a vertical line will be joined to the value of the x-axis that is 4 in the case of pointA.
And the value of the coordinates at the point which the mouseOver will be display at the interception of the two lines, that is the position of the mouse.

I am very new to flash programming and is very weak in actionscripting. After much research and thinking i can only figure out a few points:

(1) The postion of the mouse is very important.
(2) the two axis of the graph need not be dynamic ( or do they have to ? ).
(3) the horizontal and vertical "tracing lines" is dependent on the postion of
the mouse cursor as they starts from the cursor to be joined to the
various coordinates on the X and Y axis.
(4) The length of the tracing lines will definately varies depending on how
far away or how near the mouse cursor is from the axis.
(5) I have absolutely no ideal how to do the part where the value of the two
coordinates have to be show at the point where the tracing lines
intercept (the point on the graph where the mouseOver.)

I believe a lot of functions have to be written for such a graph to be programmed, but i have hardly any clue how to start, as I am a student doing a project for my school math department and the course which i took on Flash taught me merly on flash animation and basic actionscript. I borrowed lots of actionscript books from the library, but none seem to deal specifically the means and functions to do such a questions. So please teach and guide me if you can. Thanks alot

Please if you can, show me some sample functions because i can hardly come out with my own functions.

Thanks alot

[ p.s. The only way i can figure out to finish this questions is to put hundred
of movie clips (can anyone teach me how to write a loop function?) on the
graph and draw out hundred of "tracing lines" ]

regards,
LWM

Bar Graph
Can any one help me how to create bar chart(given data) in flash using actiion script..but hight should not exceed more than 215.

any idea?

Bar Graph
can anyone help me,how to create a bar graph using flash action script?

data given by user and maximum height should be 400.

thanks n advance

thil

Graph
Hello,

Can anyone help me with my graph please ?

I have two data files that populate the two different shades of blue in the bar graph. I have the dark blue one working but i cant get the light blue one to work? I origionally got the code from flashkit so i dont understand it fully..

I attached a zip of what i'm doing, just extract it all to the same place,

Thanks for any help

skid

Graph Help
I'm a newbie to actionscripting so please be patient. I'm writing a graphing application which receives information from a back end database. I have most of it figured out but I'm stumped on how I can get the values to be displayed. The number of data points is too many to put a text tag on the graph, all you see is each text tag overwritting the last. What I would like to do is have a text box on the side of the graph and as you move a line across the graph the values of the graph would be displayed in the appropriate text box. Right now I simply figure out the x and y pixel location and draw a line to that point.

Thanks.

Out Put To Excel File
Does any one know how I can have a form output to an excel document or database. As far as columns and and rows. Also can someone just tell me how to output to an text file. thanx

Flash And Excel
Can Flash movies, either as .exe, .fla, or .swf be embedded into Excel documents? If so,how? I'm not looking to have an active link to a URL, I simply want the Flash to be in the spread sheet and start when clicked on.

Excel......lent
What would be the simplest way to call the content of an excel spreadsheet cell into Flash5 ?

I've looked everywhere for an online tutorial but no luck, would I have to export the excel file to access first?

Surely not, there must be a simpler way?

any help with the script for this would be fantastic

Regards jonnyb

Url For Excel Webpage
I need help
I'm working in flash mx on a website where i would like to see a webpage made in excel saved as a excelwebpage (officexp) when i write the urlline flash doesn't find the file, a normal page no problem.
What i'm doing wrong ???????

Excel Form
Is it possible to import an excel form into Flash MX???
if that is possible, what do I have to do to make it possible??

F1-nr1

Excel To Xml To Flash
How can it be possible to use variable parameters from an excel document saved as xml? Can I create variables in xml using excel?

Excel Curiosity
I'm curious, is there anyway i can convert excel data to xml, so i can use it in flash via xml????????

or is there any integration tools for flash and excel?????

Flash And Excel
Does Flash MX have the ability to import external data from excel file?

Powerpoint And Excel
Hi - Does Flash MX have the ability to import or export from/to MS POwerpoint or MS Excel? Thanks.

Excel(CSV,XML) To Flash
Hello friends,

I've got an MS EXCEL file who's content I'd like to display inside my FLASH file. Can't use any win-compilers as the user is MAC based. I can't use SWF Studio and the likes. So I guess I'd convert the EXCEL to a CSV or XML, but they won't read properly cause Microsoft XML sucks and that's just about it. Well I guess it doesn't suck, but it is just me

in any case any tips or tricks of how I can get the data into my SWF without having to retype the whole thing...

thanks

V

EXCEL To Flash
can i load variables or data from excel to flash?

Excel To Flash?
so at work we have this big arse excel file....and the client wants it to be "prettied up". we plan to do it in flash. it needs to be pretty interactive though (when you change a number, it changes others) and we dont really have enough time to do it in flash. so does anyone know of a stand alone app that can convert an excel file to a swf..... or maybe a component for flash that allows you to import an excel file (with all of its math stuff still in tact)?

Anyone Know EXCEL > FLASH
How can I import excel date in flash text fields and be able to update and change info from the excel doc.

Or is there another way to add data to flash without manually doing it?

Please let me know lwilliams@convexgroup.com

-Landon

Excel To Flash
hi

i would like to put an excel sheet into my flash page. It doesnt have to be interactive just look like excel and scroll down available.

ideas?

thank you

Flash To Excel?
Can Flash be made to pass the variables input into text fields into cells in an Excel spreadsheet?

Excel File
Whats the best way to display data from an excel file? Thanks!,
Mike

[F5] Excel And Flash
Hello...

simple question, I'm using Flash 5 and mirosoft excel.

can I load the excel file to flash and then have a cell displayed in a text field within flash?

Thanks!

Excel To Flash?
Best way of getting structured data from Excel or Google Spreadsheets to Flash?

Are there any "customizable excel to xml converters" / "readymade classes for google data api" out there?

thanks for directions!

Flash And Excel
I am trying to figure out if there is a way to use Flash/AS to, essentially, take the math logic built into an exel document and import that functionality into Flash to make a very simple flash tool.

Basically, the excel sheet is simply a forecasting tool, used to estimate financial impacts on subtle adjustments in a handful of components in a marketing strategy. If I could lift the functionality and algorithms from the Excel sheet (or maybe export as XML?) and pull that into Flash.

Can anyone point me in the direction of anything they may have encountered/used to do this?

Thanks for your time!

Excel To Flash
hi I am pretty new to flash and need your help guys.. please I have to convert a excel document which is a small calculator that works determines package prices based on age.. its relatively simple

what is the best way for me to do this.. I need to convert the excel document to to flash so it can be placed on a website then what I would desire is a option to to print the final result to pdf.. can that be done..

I am pretty much a newbie but really need the help urgent.. thank you guys

Array To Php And Then Excel
Hi,
I'm trying to write an Excel File with values taken from a Datagrid. These values are already saved in a array as Objects with the following format {Pt:aa,X:bb, Y:cc,ddp:dd}.

I think I know how to split the values, but I'm getting any results about passing these values to the PHP, for him to make a Excel File (or csv) with values.

Anyone has any ideias... I've looked and tried somethings from myself, but I seem to get stuck on something.

You think you need some code, just tell me.

If you have any good tutorial ou web page to show, please do.

Thanks,
Leonel

Open .sol In Excel
I needed to run a simulation on my local computer and record the results. There is now an .sol file containing a handful of multidimensional arrays on my hard drive. I know that I can retrieve this data with the same .swf that generated it, but I would like to take a look at it and edit it.

Does anyone know how to parse these files in Excel? If there is no way to do this in Excel, I will look into SolVE and SOL Editor (though Iâ€™d prefer to not install any more software on my box, if possible.)

Thanks for any help.

Excel And Flash ?
Hi,

can Flash read an MS Excel file ?

We have programmed a website for a client that is completely in Flash, and the client wants to update a schedule that is shown on the page by himself, and it has to be as easy as possible...

They are already using excel for their schedule so this would be an easy option....

If you have any other ideas on how they can update their schedule, please advise...

As always, thanx for your help in advance !!!

Mike

Excel In Flash?
I'm making a site which has a lot of tables in it. But I want to make it so that I can alter those tables without have to mess constantly in the flash movie. So is it possible to load an external Excel- File into the movie?

Flash 8 Vs MS Excel
Hi All,

Please can any body help me out with a tutorials or how to load external Microosft Excel File into Flash 8 ?

Its' some what Urgent please.

FlashFile

EXCEL And FLASHMX
I wondered if it is possible to insert sections of an excel spreadsheet into flashMX with me being able to edit the excel file and it automatically updates the flash file?

If this is impossible then is there a way that I can export parts of my excel spreadsheet into flash, whilst keeping the detail but loosing some of the filesize?

I'm having major problems with this!!!!

cheers for any help,
YOURS
ASH

Flash And Excel?
Is there a way to use Flash/AS to take the math logic built into an exel document and import that functionality into Flash to make a very simple flash tool.

Basically, the excel sheet is simply a forecasting tool, used to estimate financial impacts on subtle adjustments in a handful of components in a marketing strategy. If I could lift the functionality and algorithms from the Excel sheet (or maybe export as XML?) and pull that into Flash.

Has anyone encountered/used a tool or method to do this?

Thanks for your time!

Data In Excel
Does any one know if you can create a flash front end for excel spreadsheets??

I have been asked to look into creating a cd for our pricelists that are in excel. This changes quite a lot and I would like to make this process as easy as possible for others to update.

Thanks in advance for any help/information

___________________
Manic
www.rockatpzazz.com

Flash And Excel
anyone have experience with flash and excel? i just want to put web type of pull down menus either in flash or html. i seen a software online called xcelsius that combines the two. i have already made buttons in Fireworks and assigned macros for those, does excel have pull down menus??? i could not find anything on it.

Flash To Excel
I'm involved in a project right now which requires the passing of variables collected from flash to a file [csv presumably] which can be read by excel. This project involves taking variables from flash and putting them into a file that excel can read, and also be able to add additional user data to the file as well. This has to be all client-side, and also has to be kept in mx 2004.
I realize flash alone cannot do this, does anoyone have any suggestions? (preferably without the need to purchase additional software, but if its absolutly necesary it is an option)

In theory, using "Jugglor", flash can save a .txt file (mx 2004), but i don't know how helpful that is considering the data has to be saved in an ongoing/updatable file. Using this option, the file would be saved over and the previouse user data lost.

a large piece of cake to anyone who can solve this problem, since time is of the essence...

Polar Graph
Hi.

I have a really big trouble. I need to make a polar graph and I have not idea how can I do.

Thanks for anyone that can help me

Plotting A Graph
Im starting to wonder if this can be done or not, I have posted on several sites and have not gotten any replys so this will be the last try. What I am trying to do is make a flash interfase that will have a range lets say from the bottam left of 0 to the top say 100, now what I want to do is be able to have flash get the information from my data base on stocks and take lets say x=9 and y=2 then draw me a simple line on the chart showing the percent of growth of that stock. any ideas if this can even be done or perhaps if the Gods are smileing on me a tutorial that may be out there some were I have not looked that might lead me in the right direction. thanks in advance.

Dynamic Graph
does anyone have or can point me where i can find a dynamic graph aside from the tute here in flash. i want a dynamic graph tute with an option to display the exact values of the graph or sumthin like a legend for the values. i hope there's one out there .. i badly need one a.s.a.p. thanks a lot guys!!! =)

Dynamic Bar Graph
I may be imagining things, but I remember seeing a component in Flash MX for building dynamic bar graphs. has anyone else seen it? If it doesn't exist, what can you recommend for doing bar graphs?