Hi All..
Any idea how to lookup a picture generate at the chart based on value at a cell...
The lookup picture created at the chart
Thank you very much
Hi All..
Any idea how to lookup a picture generate at the chart based on value at a cell...
The lookup picture created at the chart
Thank you very much
Sorry I don't understand the question. Can you try re phrasing it?
What i meant is, when i select a dropdown list of name (data validation), it will show a picture based on list i pick from dropdownlist (data validation), but the picture is at the chart. like an autoshape lookup, but it is chart.
fyi: the picture already named like list at data validation
for clear explanation:
when i pick "apple" from data validation then the chart changed to an apple picture
when i pick "orange" from data validation then the chart changed to an orange picture
Last edited by xltony; 12-13-2008 at 11:22 AM.
Thank you for the response Sir Andy,
I already download the file
The file is what i really want to
it will be more appreciated if the step by step to do that is here
i dont have any idea how to make it
Last edited by xltony; 12-13-2008 at 12:03 PM.
There are instruction inside the file.
Basically you need a xy-scatter chart with a series that has enough data points to hold each picture as a custom marker.
You use copy+paste to apply each picture to a specific data point.
You then use formula to display 1 of the points/pictures inside the charts plotarea. The others are all positioned off the plot area.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks