View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kiwis kiwis is offline
external usenet poster
 
Posts: 24
Default 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