| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I want the bar chart with customer selected colors, green color f.
I want to create a bar chart with the following spec.
the first bar with green color the 2nd bar with blue color the 3rd and beyond with red color |
|
#2
|
|||
|
|||
|
Select the chart
Right-click on a bar, and choose Format Data Series On the Patterns tab, select an Area colour Click OK junminliu wrote: I want to create a bar chart with the following spec. the first bar with green color the 2nd bar with blue color the 3rd and beyond with red color -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
An option would be to set the color palette appropriately (Tools |
Options... | Color tab) and then for the chart set the 'vary color by points' option. To access the last one double-click the plotted series and in the resulting dialog box select the Options tab. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I want to create a bar chart with the following spec. the first bar with green color the 2nd bar with blue color the 3rd and beyond with red color |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change all chart colors to black and white? | Charts and Charting in Excel | |||
| How do i stop the colors changing on my pivot chart when i refres. | Excel Discussion (Misc queries) | |||
| Create chart Base on selected Period | Charts and Charting in Excel | |||
| Text manipulaion (summarizing customer records) Index function probably not good choice | Excel Discussion (Misc queries) | |||
| Determining if a chart is selected | Charts and Charting in Excel | |||
Linear Mode
