| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Highlighting one chart item
Please could you explain how I would highlight by changing the colour/fill of
one bar in a column chart so that it stands out from the rest of the data series? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Highlighting one chart item
Hi,
Use 2 series plotted either as stacked column or clustered column with 100 overlap. Use the second series to plot the highlighted value, with all other values being zero or blank. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "stephan" wrote in message ... Please could you explain how I would highlight by changing the colour/fill of one bar in a column chart so that it stands out from the rest of the data series? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Highlighting one chart item
Simpler but less flexible:
Single click on the bar twice, once to select the whole series, the second time to select the point. Press Ctrl+1 (numeral one) to bring up the formatting dialog. Pick your formats for the selected point. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Andy Pope" wrote in message ... Hi, Use 2 series plotted either as stacked column or clustered column with 100 overlap. Use the second series to plot the highlighted value, with all other values being zero or blank. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "stephan" wrote in message ... Please could you explain how I would highlight by changing the colour/fill of one bar in a column chart so that it stands out from the rest of the data series? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Highlighting one chart item
Thank you to both you gentleman, both solutions worked well!!
"Jon Peltier" wrote: Simpler but less flexible: Single click on the bar twice, once to select the whole series, the second time to select the point. Press Ctrl+1 (numeral one) to bring up the formatting dialog. Pick your formats for the selected point. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Andy Pope" wrote in message ... Hi, Use 2 series plotted either as stacked column or clustered column with 100 overlap. Use the second series to plot the highlighted value, with all other values being zero or blank. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "stephan" wrote in message ... Please could you explain how I would highlight by changing the colour/fill of one bar in a column chart so that it stands out from the rest of the data series? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlighting different sections of a line chart | Charts and Charting in Excel | |||
| Scatter Chart Data Point Highlighting | Charts and Charting in Excel | |||
| Org Chart Item Automatic Font | Charts and Charting in Excel | |||
| Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
| How to build a chart with 2 values per item? | Charts and Charting in Excel | |||
Linear Mode
