How do I select multiple data points on my chart?
I have a chart and the x axis is by quarter for multiple regions. I want to
select the individual quarters for all the regions and change the formating of those data points - e.g. all first quarters in blue. I can do it by selecting them one at a time, but how do I select all data points for the first quarter, etc., etc. I tried holding the shift key and the control key - but ng. |
You can only select one data point at a time, or the entire series.
If I need to do some kind of special formatting like this, I turn the one series into several, each with its own formatting. See this page for examples: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Matthew S wrote: I have a chart and the x axis is by quarter for multiple regions. I want to select the individual quarters for all the regions and change the formating of those data points - e.g. all first quarters in blue. I can do it by selecting them one at a time, but how do I select all data points for the first quarter, etc., etc. I tried holding the shift key and the control key - but ng. |
All times are GMT +1. The time now is 02:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com