hey all
I have created a simple chart and a graph using the same information and now trying to use the camera function to create a snazzy feature.
im wanting to create an ability where i can use a validation box with the words "chart" and "table" and as the user selects the appropriate option, the image below changes to either, the chart or the graph.....
I know this is possible however I can't get it to work and I cant seem to be able to use the camera function on a chart??? how come, ive seen this done.
I know a macro could do it but ive heard this is a very simple thing to do....im stumped?
any ideas guys
I have created a simple chart and a graph using the same information and now trying to use the camera function to create a snazzy feature.
im wanting to create an ability where i can use a validation box with the words "chart" and "table" and as the user selects the appropriate option, the image below changes to either, the chart or the graph.....
I know this is possible however I can't get it to work and I cant seem to be able to use the camera function on a chart??? how come, ive seen this done.
I know a macro could do it but ive heard this is a very simple thing to do....im stumped?
any ideas guys