Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
All,
Here's what I CAN do, but don't want: Publish a chart as a web page that also includes an embedded spreadsheet with limited functionality. Details: 1 - Use Save As Web Page command for chart 2 - In the Save As dialog box, leave Add Interactivity unchecked and click Publish. 3 - In the Publish as Web Page dialog box, under Viewing Options, check Add Interactivity With: Chart Functionality (the only choice from my drop-down). 4 - Click Publish, and the web page opens up with a little embedded spreadsheet with limited functionality--I can sort, sum, delete, and change cell data, but I can't add or delete rows or columns. This embedded spreadsheet has that Excel logo in the upper-left corner, and when I click that I get a window saying "Microsoft Office Web Components" with version info, which indicates to me that I DO have OWC. The chart, however, has no interactivity with the spreadsheet from which it was generated. Here's what I CANNOT do, but want: Publish a chart as a web page that has interactivity with the spreadsheet from which it was generated. i.e., if I update the spreadsheet, the chart updates on the web. This is for company intranet, not www. Details: 1 - Use Save As Web Page command for chart 2 - In the Save As dialog box, check Add Interactivity and click Publish. 3 - In the Publish as Web Page dialog box, under Viewing Options, leave Add Interactivity UNchecked. 4 - Click Publish, and get a chart that has interactivity with the spreadsheet from which I generated it. But it ain't happening. Is this possible? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Leading Zeros with a twist. | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |