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  

Driving me nuts! Help!



 
 
Thread Tools Display Modes
  #1  
Old September 18th, 2003, 08:38 PM
excelguy78
external usenet poster
 
Posts: n/a
Default Driving me nuts! Help!

I'm new to this forum, but I am so happy I found it. I'm having a
charting problem in Excel that has been driving me nuts! I'm creating a
chart based on weekly data. So I have a chart that is broken down by
week as follows 09/07/03, 09/14/03, 09/21/03, 09/28/03. But this week
when I entered the data for the 14th, there was a huge gap in my chart
between 09/07 and 09/14. My question is how can I get Excel to only
great a stacked graph for 09/07 and 09/14 so that they appear side by
side. It looks like Excel wants to fill in the data for the days
inbetween weeks (09/08-09/13). Hopefully somebody can help. If you need
me to attach a pic just let me know. Thanks!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

  #2  
Old September 18th, 2003, 10:41 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default Driving me nuts! Help!

You can change the x-axis setting:

1. Select the chart
2. Choose ChartOptions
3. Select the Axes tab
4. For Category (x) axis, choose Category, click OK

excelguy78 wrote:
I'm new to this forum, but I am so happy I found it. I'm having a
charting problem in Excel that has been driving me nuts! I'm creating a
chart based on weekly data. So I have a chart that is broken down by
week as follows 09/07/03, 09/14/03, 09/21/03, 09/28/03. But this week
when I entered the data for the 14th, there was a huge gap in my chart
between 09/07 and 09/14. My question is how can I get Excel to only
great a stacked graph for 09/07 and 09/14 so that they appear side by
side. It looks like Excel wants to fill in the data for the days
inbetween weeks (09/08-09/13). Hopefully somebody can help. If you need
me to attach a pic just let me know. Thanks!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3  
Old September 18th, 2003, 10:45 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default Driving me nuts! Help!

Hey Guy -

Excel recognizes the dates you are inputting, and wants to use a time
scale axis. But that means it leaves room on the chart for each day, so
your columns have six blank spaces between adjacent pairs of data.

Right click on the chart, select Chart Options from the pop up menu, and
click on the Axes tab. Choose the Category option under Category Axis
(not Automatic or Time Scale).

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

excelguy78 wrote:
I'm new to this forum, but I am so happy I found it. I'm having a
charting problem in Excel that has been driving me nuts! I'm creating a
chart based on weekly data. So I have a chart that is broken down by
week as follows 09/07/03, 09/14/03, 09/21/03, 09/28/03. But this week
when I entered the data for the 14th, there was a huge gap in my chart
between 09/07 and 09/14. My question is how can I get Excel to only
great a stacked graph for 09/07 and 09/14 so that they appear side by
side. It looks like Excel wants to fill in the data for the days
inbetween weeks (09/08-09/13). Hopefully somebody can help. If you need
me to attach a pic just let me know. Thanks!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/


  #4  
Old September 19th, 2003, 06:09 PM
dvt
external usenet poster
 
Posts: n/a
Default Driving me nuts! Help!

excelguy78 wrote:
I'm new to this forum, but I am so happy I found it. I'm having a
charting problem in Excel that has been driving me nuts! I'm creating
a chart based on weekly data. So I have a chart that is broken down by
week as follows 09/07/03, 09/14/03, 09/21/03, 09/28/03. But this week
when I entered the data for the 14th, there was a huge gap in my chart
between 09/07 and 09/14. My question is how can I get Excel to only
great a stacked graph for 09/07 and 09/14 so that they appear side by
side. It looks like Excel wants to fill in the data for the days
inbetween weeks (09/08-09/13). Hopefully somebody can help. If you
need me to attach a pic just let me know. Thanks!


Based on your username, I'll assume you know how to change the Gap width in
a column chart to eliminate spaces. If not, try that first.

Next step: check out Jon Peltier's directions to eliminate blank spaces
between columns:
http://www.geocities.com/jonpeltier/...zeColumns.html

If neither of these works, post back with a few rows/columns of
representative data from your spreadsheet.

Dave
dvt at psu dot edu


 




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 02:08 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.