| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart -- Source Data... -- Series dialog window | Charts and Charting in Excel | |||
| How to hide a dummy series in a chart legend? | New Users to Excel | |||
| How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
| series graph -- one series being added to another series | Charts and Charting in Excel | |||
| How do I shade the space between two data series in Excel? | Charts and Charting in Excel | |||
Linear Mode
