ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Space between series (https://www.excelbanter.com/excel-worksheet-functions/91293-space-between-series.html)

Dewayne

Space between series
 
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!
--
Dewayne

Marcelo

Space between series
 
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:

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!
--
Dewayne



All times are GMT +1. The time now is 08:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com