PDA

View Full Version : Creating a dynamic chart using the value of a data validation



jay2ayo
02-19-2011, 08:21 PM
Pls help, I need to create a MS Excel chart from the current value of a data validation list.The chart should show an upward movement and its a single line chart,its meant to show the movement from the starting point to the end point.
illustration.
region -------country-----------state----------city---------street
North America -------USA ------------- NY----NYC--------Murray Hill

IBihy
02-21-2011, 09:56 AM
Hi jay2ayo,

how about attaching a workbook? Otherwise, it becomes extremely hard to figure out what you want. BTW, charts are best if you have numbers to plot. The text above is, well, text.