Chart data series colors

  • Thread starter Thread starter QB
  • Start date Start date
Q

QB

I created a chart (Bar chart) and need to accomplish 2 things and can`t.

1- How can I set it so all the bar are the same color. I tried setting the
data series properties, but it does not apply the selection to all.

2- How can I reduce the margin between the columns (Way too much wasted
space)?

I looked over a couple tutorial but they haven`t worked for me?! I must be
doing something wrong but can`t figure out what.

Thank you,

QB
 
You should be able to select any series and set the color to whatever you
want. At the same time, you can select a series and set the "Gap Width" under
the Format Data Series->Options.
 
Is there a way to set it up so all the data series have the same format
(color in this case)? The chart is based on a query and thus the number of
data series will change depending on user specified criteria and so I would
like to have a uniform look, say all bars (in the bar chart) blue.

I will look into the "Gap Width" property.

Thank you,

QB
 
If you can't update the color in design view, you should be able to do this
with code. It would require you to understand something about the chart
control object model. I generally record a macro in Excel while manipulating
the chart and the copy the code into the Access report. It generally takes a
little modification to get it to work.
 
Back
Top