![]() |
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 |
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