Is there a way to change ALL of my chart from a bar graph
to an X-Y or line chart? I have 27 charts on thier on
sheet. I want to be able to have a button that runs a
macro that will change all the chart to bar, then another
to change it back to a line chart?

Any thought?