If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Scatter chart, conditional format data points
If you change one point, then select the next and press the F4 key, it
repeats the format on the next point. To really save time, try the Conditional Chart example on my web site: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Sprinkles wrote: Is there any way to format several nonadjacent points on a scatter chart in the same way with few steps? At the moment I am clicking on each one and changing the color manually. Can I put a some sort of signal in the source data spreadsheet? Thanks for your time! --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|