Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create chart in worksheet but hide the data from user
Hi
Is there any way to hide the data from user & just create & show the chart? I have the data on sheet 1 & i created the chart to be shown on sheet 1. But i want to just show the chart only, do i create the chart in vba? Sample of of my data on sheet 1 A1 B1 pd1 15 pd2 2 pd3 28 i'm creating the bar chart. Thank you for providing any ideas. rgds kiwis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
create chart in worksheet but hide the data from user
Hi kwis,
Some ideas, - Put your data on an xlVeryHidden sheet Store data in Named formulas (the Names can be programmatically hidden) For smallish Series such as you indicated, values can be as arrays in the Series formula {1,2,3} Protect Objects to prevent viewing the formula bar. Shift Edit Copy Picture, paste back, delete the original chart. Regards, Peter T "kiwis" wrote in message ups.com... Hi Is there any way to hide the data from user & just create & show the chart? I have the data on sheet 1 & i created the chart to be shown on sheet 1. But i want to just show the chart only, do i create the chart in vba? Sample of of my data on sheet 1 A1 B1 pd1 15 pd2 2 pd3 28 i'm creating the bar chart. Thank you for providing any ideas. rgds kiwis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
Long time user,can't create a chart-help! | Charts and Charting in Excel | |||
Hide the tab with the data associated with a chart | Charts and Charting in Excel | |||
Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
How do i create a user defined chart in Powerpoint or excel? | Charts and Charting in Excel |