LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default How do I make a 2 x axis series bars larger?

Hi,

The columns are skinny as they are representing 1 day in your date
period. You can increase the thickness by double clicking and setting
the Gap width to zero on the Series Option tab. The increase will not be
huge though.
If your dates are of equal intervals, i.e. 12 data points for each year,
you could set the axis to be Category rather than Time series. Right
click the chart and pick Chart Options. On the Axes tab you can specify
the axis type.

Cheers
Andy

tdebo wrote:
I have created a 2 series basic column chart. It has dates as the primary
axis with years as the secondary. It is comparing data from each month year
over year, across 3 years. And it's comparing two types of data, calls
offered, and calls answered. Needless to say, it's a rather busy chart. The
only problem I have with it right now, is that given the type of chart and
all the data, the columns are SUPER skinny. Is there a way to manually make
the columns fatter? Please help! Thanks!!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want graph with 2 axis, but bars overlap when second axis added Gill Charts and Charting in Excel 6 April 29th 23 07:43 PM
Ho do I make my data series touch the axis? RSunday Charts and Charting in Excel 1 February 6th 08 08:22 PM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Excel Discussion (Misc queries) 3 May 4th 06 01:58 AM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Charts and Charting in Excel 2 May 4th 06 01:58 AM
How to make Three Bars and one line with a second axis in EXCEL JAS123 Charts and Charting in Excel 1 June 9th 05 02:48 PM


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"