A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Bars



 
 
Thread Tools Display Modes
  #1  
Old September 26th, 2003, 07:28 PM
Mary Ann
external usenet poster
 
Posts: n/a
Default Bars

I've been working on this project for some time now, &
have resorted to a pie chart instead of the bars that is
preferred. When I select the chart type, for ex. for 3D
all I get is narrow lines. I have even downloaded the MS
excel patch thinking there might be a glitch in the
software but still unsuccessful. Any help I can get will
be appreciated. Thank you
  #2  
Old September 26th, 2003, 09:45 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default Bars

[This followup was posted to microsoft.public.excel.charting with an
email copy to Mary Ann.
Please use the newsgroup for further discussion.]

What do you have on the x-axis of the bar (column?) chart? Are they
dates? If so, what is their range?

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I've been working on this project for some time now, &
have resorted to a pie chart instead of the bars that is
preferred. When I select the chart type, for ex. for 3D
all I get is narrow lines. I have even downloaded the MS
excel patch thinking there might be a glitch in the
software but still unsuccessful. Any help I can get will
be appreciated. Thank you

  #3  
Old September 27th, 2003, 01:46 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default Bars

I bet she has dates, and Excel is imposing a time scale axis. Right
click on the chart, choose Chart Options from the pop up, click on the
Axes tab, and under Category, choose Category instead of Automatic or
Time Scale.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Tushar Mehta wrote:
[This followup was posted to microsoft.public.excel.charting with an
email copy to Mary Ann.
Please use the newsgroup for further discussion.]

What do you have on the x-axis of the bar (column?) chart? Are they
dates? If so, what is their range?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.