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  

Chart formatting problems (multiple)



 
 
Thread Tools Display Modes
  #1  
Old March 2nd, 2010, 04:01 AM posted to microsoft.public.excel.charting
WhiskyCast
external usenet poster
 
Posts: 2
Default Chart formatting problems (multiple)

Using Excel 2007, and having problems with simple column graphs. The first
half of my data points align properly with the gridlines along the Y axis,
but halfway through, they move consistently to the right of the gridlines for
the rest of the series. What's worse, no matter what column chart style I
select, all I get is a bold vertical line with no shading or 3D appearance
(it will pick up the color from the style I select).

I've posted a .pdf showing what I'm talking about at
www.caskstrengthmedia.com/ExcelHelp.pdf -- hope this may help explain my
problem.

Any suggestions?

Thanks!
  #2  
Old March 2nd, 2010, 04:34 AM posted to microsoft.public.excel.charting
Ed Ferrero[_3_]
external usenet poster
 
Posts: 102
Default Chart formatting problems (multiple)

Hi WhiskyCast,

A couple of guesses;

Format the cells containing the 'months' to dd-mmm-yy. Do you have months
starting on different days?

Right-click the series. Choose 'Format data Series' from the context menu.
Use the Gap width slider to make the gap between columns smaller.

Ed Ferrero
www.edferrero.com


  #3  
Old March 2nd, 2010, 06:34 PM posted to microsoft.public.excel.charting
WhiskyCast
external usenet poster
 
Posts: 2
Default Chart formatting problems (multiple)

Sorry...neither trick worked. Tried the "Format Data Series" command many
times, but nothing seems to help.

Thanks for trying!

Mark

"Ed Ferrero" wrote:

Hi WhiskyCast,

A couple of guesses;

Format the cells containing the 'months' to dd-mmm-yy. Do you have months
starting on different days?

Right-click the series. Choose 'Format data Series' from the context menu.
Use the Gap width slider to make the gap between columns smaller.

Ed Ferrero
www.edferrero.com


.

  #4  
Old March 2nd, 2010, 06:41 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Chart formatting problems (multiple)

Your data comes once a week, right? A date scale axis with a base unit
of days has room for one data point (column) per day, so weekly data has
one skinny column and six skinny blank slots per week.

You could change the axis to a text style.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/1/2010 10:01 PM, WhiskyCast wrote:
Using Excel 2007, and having problems with simple column graphs. The first
half of my data points align properly with the gridlines along the Y axis,
but halfway through, they move consistently to the right of the gridlines for
the rest of the series. What's worse, no matter what column chart style I
select, all I get is a bold vertical line with no shading or 3D appearance
(it will pick up the color from the style I select).

I've posted a .pdf showing what I'm talking about at
www.caskstrengthmedia.com/ExcelHelp.pdf -- hope this may help explain my
problem.

Any suggestions?

Thanks!

  #5  
Old March 5th, 2010, 02:06 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Chart formatting problems (multiple)

Once a month data is even worse than once a week. However, one of the
Base Unit settings for a date scale axis is Monthly, which should fix
your chart. There is also Daily, but not Weekly.

Make the chart 2D too, so it looks nicer and doesn't distort the values.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/2/2010 12:41 PM, Jon Peltier wrote:
Your data comes once a week, right? A date scale axis with a base unit
of days has room for one data point (column) per day, so weekly data has
one skinny column and six skinny blank slots per week.

You could change the axis to a text style.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/1/2010 10:01 PM, WhiskyCast wrote:
Using Excel 2007, and having problems with simple column graphs. The
first
half of my data points align properly with the gridlines along the Y
axis,
but halfway through, they move consistently to the right of the
gridlines for
the rest of the series. What's worse, no matter what column chart style I
select, all I get is a bold vertical line with no shading or 3D
appearance
(it will pick up the color from the style I select).

I've posted a .pdf showing what I'm talking about at
www.caskstrengthmedia.com/ExcelHelp.pdf -- hope this may help explain my
problem.

Any suggestions?

Thanks!

 




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 07:31 PM.


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