Working with Charts from a spreadsheet

A

Anthony Blackburn

I am trying to get a chart to shw up on my website.

Currently, I create a chart using the chart wizard, from excel, and copy and
paste it in place in FrontPage.

I would like to have the spreadsheet in the website, but not visible, as the
source for the data in the chart, which I wish to be visible. I have tried
inserting a web object, but that doesn't seem to quite do it.

My end result should look like this page:
http://www.goapple.com/statistics/Alameda.htm

Thanks for input
 
R

Rob Giordano \(Crash\)

An easy way would be to take a screenshot of the excel page with the chart
displayed. (PrtScrn key on keyboard) then open your favorite image editor
and Paste, Crop. Resize and Save it as a jpg or gif. Then import the image
into FP and from there place it into your layout.


message |I am trying to get a chart to shw up on my website.
|
| Currently, I create a chart using the chart wizard, from excel, and copy
and
| paste it in place in FrontPage.
|
| I would like to have the spreadsheet in the website, but not visible, as
the
| source for the data in the chart, which I wish to be visible. I have tried
| inserting a web object, but that doesn't seem to quite do it.
|
| My end result should look like this page:
| http://www.goapple.com/statistics/Alameda.htm
|
| Thanks for input
 
A

Anthony Blackburn

Yes, that is what I did on that site.

The issue for me is that I would like to update the data in the spreadsheet
and have it update the chart automatically, all within the website.

I want to try and get away from all the copying and pasting I am having to do.

Tony
 
R

Rob Giordano \(Crash\)

I've never done this, but you may try Insert | Web Component | Spreadheets &
Charts...looks like you may be able to (?).


message | Yes, that is what I did on that site.
|
| The issue for me is that I would like to update the data in the
spreadsheet
| and have it update the chart automatically, all within the website.
|
| I want to try and get away from all the copying and pasting I am having to
do.
|
| Tony
|
| "Dan L" wrote:
|
| > That's what goapple.com did. Those graphs are gifs.
| >
| > "Rob Giordano (Crash)" wrote:
| >
| > > An easy way would be to take a screenshot of the excel page with the
chart
| > > displayed. (PrtScrn key on keyboard) then open your favorite image
editor
| > > and Paste, Crop. Resize and Save it as a jpg or gif. Then import the
image
| > > into FP and from there place it into your layout.
| > >
| > >
in
| > > message | > > |I am trying to get a chart to shw up on my website.
| > > |
| > > | Currently, I create a chart using the chart wizard, from excel, and
copy
| > > and
| > > | paste it in place in FrontPage.
| > > |
| > > | I would like to have the spreadsheet in the website, but not
visible, as
| > > the
| > > | source for the data in the chart, which I wish to be visible. I have
tried
| > > | inserting a web object, but that doesn't seem to quite do it.
| > > |
| > > | My end result should look like this page:
| > > | http://www.goapple.com/statistics/Alameda.htm
| > > |
| > > | Thanks for input
| > >
| > >
| > >
 
A

Anthony Blackburn

Yes, I have gone down that path. I can get a chart up, but I cant format it
correctly. I have dates on the bottom and number of days on the left side and
if I leave the file, it seems to try and multiply them.
 
S

Stefan B Rusynko

See http://office.microsoft.com/en-us/assistance/HP030852911033.aspx
- users must have Excel and OWC installed

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Yes, I have gone down that path. I can get a chart up, but I cant format it
| correctly. I have dates on the bottom and number of days on the left side and
| if I leave the file, it seems to try and multiply them.
|
| "Rob Giordano (Crash)" wrote:
|
| > I've never done this, but you may try Insert | Web Component | Spreadheets &
| > Charts...looks like you may be able to (?).
| >
| >
| > message | > | Yes, that is what I did on that site.
| > |
| > | The issue for me is that I would like to update the data in the
| > spreadsheet
| > | and have it update the chart automatically, all within the website.
| > |
| > | I want to try and get away from all the copying and pasting I am having to
| > do.
| > |
| > | Tony
| > |
| > | "Dan L" wrote:
| > |
| > | > That's what goapple.com did. Those graphs are gifs.
| > | >
| > | > "Rob Giordano (Crash)" wrote:
| > | >
| > | > > An easy way would be to take a screenshot of the excel page with the
| > chart
| > | > > displayed. (PrtScrn key on keyboard) then open your favorite image
| > editor
| > | > > and Paste, Crop. Resize and Save it as a jpg or gif. Then import the
| > image
| > | > > into FP and from there place it into your layout.
| > | > >
| > | > >
| > in
| > | > > message | > | > > |I am trying to get a chart to shw up on my website.
| > | > > |
| > | > > | Currently, I create a chart using the chart wizard, from excel, and
| > copy
| > | > > and
| > | > > | paste it in place in FrontPage.
| > | > > |
| > | > > | I would like to have the spreadsheet in the website, but not
| > visible, as
| > | > > the
| > | > > | source for the data in the chart, which I wish to be visible. I have
| > tried
| > | > > | inserting a web object, but that doesn't seem to quite do it.
| > | > > |
| > | > > | My end result should look like this page:
| > | > > | http://www.goapple.com/statistics/Alameda.htm
| > | > > |
| > | > > | Thanks for input
| > | > >
| > | > >
| > | > >
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top