Same Y Axis name for multiple charts

[Mike B]

I have 3 charts per worksheet which need to use the same Y value on
another sheet - Range A1 through A14 on worksheet ChartNames.

Every day I bring in new data for 3 different charts. I'd like all 3
to use the same Y name but without having to manually edit the Series
information in the forula bar.

Is there a quick and easy way to do this? Currently I copy the same
chart from page to page and select the new data range and then
manually edit the Series Name, 1 at a time for 14 Series.

Hope you guys can help,

Mike B

 

[dvt]

Do you mean the same thing when you say "Y value" (first paragraph),
"Y name" (second paragraph), and "Series Name" (third paragraph)? I
suspect you might mean "Series Name" in each of these instances, but
I'm not sure.

I was also confused by the "Y Axis name" in the subject line. Is that the
same as the other three?

Dave
dvt at psu dot edu