Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
tick mark labels | Charts and Charting in Excel | |||
Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |