A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel 2007 - publish chart as htm web page file



 
 
Thread Tools Display Modes
  #1  
Old March 11th, 2010, 04:05 AM posted to microsoft.public.excel.charting
nflfan
external usenet poster
 
Posts: 12
Default Excel 2007 - publish chart as htm web page file

When I select a chart in Excel 7 and select Save As, I can choose file type
Web Page (.htm file) just like in 2003, but it no longer gives the option to
select just the chart. How do you save just the chart as a web page rather
than the whole sheet or whole file?

This was a simple processs in Excel 2003:

1. Create chart and do "Save as Web Page."
2. Click on the "Selection: Chart" radio button.
3. Set your file name and location, then click "Publish."
4. Verify the info on the Publish as Web Page display and click "Open
published Web page in broswer" so that you can easily copy the URL from the
page created. Click "Publish."
5. Copy the URL of htm page displayed.
6. Insert Page Viewer Web Part on SharePoint page.
7. Select "Web Page" in Page Viewer Tool Pane and paste the htm page link
under "Link."
8. Adjust size of Web Part as needed to fit chart and eliminate scroll bars,

But....this process no longer works for me in 2007.
  #2  
Old March 12th, 2010, 04:05 PM posted to microsoft.public.excel.charting
AdamV[_2_]
external usenet poster
 
Posts: 38
Default Excel 2007 - publish chart as htm web page file

Have you tried moving the chart to a sheet on it's own, ie a chart
sheet, not a worksheet?
right click move, choose new chart sheet, click OK, do the save
procedure you describe (when you publish it will show this as the only
object on that sheet)

HTH
Adam

On 11/03/2010 03:05, nflfan wrote:
When I select a chart in Excel 7 and select Save As, I can choose file type
Web Page (.htm file) just like in 2003, but it no longer gives the option to
select just the chart. How do you save just the chart as a web page rather
than the whole sheet or whole file?

This was a simple processs in Excel 2003:

1. Create chart and do "Save as Web Page."
2. Click on the "Selection: Chart" radio button.
3. Set your file name and location, then click "Publish."
4. Verify the info on the Publish as Web Page display and click "Open
published Web page in broswer" so that you can easily copy the URL from the
page created. Click "Publish."
5. Copy the URL of htm page displayed.
6. Insert Page Viewer Web Part on SharePoint page.
7. Select "Web Page" in Page Viewer Tool Pane and paste the htm page link
under "Link."
8. Adjust size of Web Part as needed to fit chart and eliminate scroll bars,

But....this process no longer works for me in 2007.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.