View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] crinehar@gmail.com is offline
external usenet poster
 
Posts: 2
Default Changing color of single bar based on x-axis date value

I have a bar chart with numeric values for the y-axis, and Month-Year
values for the x-axis values. I would like to be able to use VBA to
change the color of just one of the bars whose x-axis value corresponds
to a specific month-year, like Jun-05 (The month-year could be text, if
that makes the example easier). Does anyone have a snippet of code that
would allow me to automate the coloring of just one bar based on the
x-axis value?

Thanks,

Carroll Rinehart
Bel Air, MD