ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Quickly Changing Several Series to Appear the Same (https://www.excelbanter.com/charts-charting-excel/11868-quickly-changing-several-series-appear-same.html)

Barb Reinhardt

Quickly Changing Several Series to Appear the Same
 
I know I've seen a post in this group that tells how to make several
different series appear to be the same in an Excel graph without manually
changing each series and I'm unable to find it. Can someone assist?

Thanks in advance,
Barb Reinhardt



Andy Pope

Hi Barb,

Can you make use of the F4 key.
Make the changes to one series and the select the next and press F4

Cheers
Andy

Barb Reinhardt wrote:
I know I've seen a post in this group that tells how to make several
different series appear to be the same in an Excel graph without manually
changing each series and I'm unable to find it. Can someone assist?

Thanks in advance,
Barb Reinhardt



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Barb Reinhardt

Doh! Thanks!
"Andy Pope" wrote in message
...
Hi Barb,

Can you make use of the F4 key.
Make the changes to one series and the select the next and press F4

Cheers
Andy

Barb Reinhardt wrote:
I know I've seen a post in this group that tells how to make several
different series appear to be the same in an Excel graph without

manually
changing each series and I'm unable to find it. Can someone assist?

Thanks in advance,
Barb Reinhardt



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info





All times are GMT +1. The time now is 10:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com