Space between series

G

Guest

I use a bar chart to chart 3 years by rows (2004, 2005, 2006) by the quarter
(1st qrt, 2nd qtr, 3rd qtr, 4th qtr & Total) on the X axis. Currenlty, the
data points run together between the years. Is there a method of having a
small space between the years (data points) on the X axis? I have tried
using blank cells in the data source but that leaves too large of a space and
takes up too much charting area.
Thanks for any help!
 
G

Guest

Dewayne, did you try to format the series on the Option box?
there are a box to change the bar width the default is 150.

hope it helps
regards from Brazil
Marcelo

"Dewayne" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal 2
Formula is being quirky 10
=AVERAGE(IF(INT(MONTH(C:C)+2/3)=4 5
Converting Dates to Fiscal Year Quarters 2
Bar chart with XY on secondary axis 2
CHARTS: combination 1
date into current and previous quarters 3
Counting or summing up a group of cells with dates as datas 3

Top