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

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