#1   Report Post  
Old December 5th 12, 10:02 PM
Member
 
First recorded activity by ExcelBanter: Nov 2012
Posts: 40
Default Skinny bars?

Hello,

I have a bar chart. One axis is by week (Oct through Dec). Somehow the thick bars turned super duper skinny. I tried the gap controls etc. and it didn't work (still super skinny and far apart). This is Excel 2010. Any ideas?

When I change the weeks from actual dates to "week1, week2, week3" it goes back to normal, but I need it to list the dates (not just week 1 etc.). I've tried everything. Help!

Thanks,

J-

  #2   Report Post  
Old January 25th 13, 10:16 PM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 12
Default

Hi JonathanK

I believe that it is because excel is putting in every date in your range and thus adding many more data points and making your columns very small.

There is a setting in the Horizontal Axis where you can force Excel to either do dates or text axis.

Check that box to solve your problem.

Steve=True
  #3   Report Post  
Old April 3rd 13, 12:47 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 5
Default Skinny bars?

On Wednesday, December 5, 2012 5:02:14 PM UTC-5, JonathanK1 wrote:
Hello,



I have a bar chart. One axis is by week (Oct through Dec). Somehow the

thick bars turned super duper skinny. I tried the gap controls etc. and

it didn't work (still super skinny and far apart). This is Excel 2010.

Any ideas?



When I change the weeks from actual dates to "week1, week2, week3" it

goes back to normal, but I need it to list the dates (not just week 1

etc.). I've tried everything. Help!



Thanks,



J-









--

JonathanK1


sounds like your axis is in date format. Excel detected the dates.
Change it to another option and you will be ok.

Bob


Reply
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
Excel 2007 is charting skinny lines instead of columns Carla Charts and Charting in Excel 9 February 11th 10 10:57 AM
Customise error bars on individual bars in a bar chart 2007 Millie Charts and Charting in Excel 2 April 25th 09 04:16 AM
How can I change a graph with 2 bars,2 lines to 3 bars, 1 line? IOWAJulie Charts and Charting in Excel 3 October 19th 05 11:13 PM
Lost all my menu bars and tool bars CathyJ Excel Discussion (Misc queries) 3 August 8th 05 12:49 PM
linking chart menu bars and worksheet menu bars majikman[_8_] Excel Programming 0 May 10th 04 09:45 PM


All times are GMT +1. The time now is 01:21 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017