LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

What's happening is the X axis is a time scale, with the base unit as
days. The maximum width for a column is one day, and because of gap
width, it's generally less. The columns are so narrow that the border
coveres up the fill.

You could change the axis type from automatic or time-scale to category
(Chart menu Chart Options Axes tab), but this removes a nice
functionality of the chart, and you've already rejected this approach.

You can also change the column formatting so that the border matches the
fill, or remove the border altogether.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Father Garrin wrote:
I have Excel 2002. I am trying to create a clustered column chart with a
time-scale x-axis. It seems to create the chart, but it limits it to black
and white, with skinny little columns that you can hardly distinguish. As
soon as I eliminate the dates along the x axis, it turns into technicolor.
But that isn't what I need. Help!

 
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
Can I combine a stacked and clustered column chart in Excel Tim Donnelly Charts and Charting in Excel 7 October 8th 09 08:17 PM
Excel: is it possible to move column contents into a line Ginger Excel Discussion (Misc queries) 2 June 16th 05 06:59 PM
How to draw an line chart starting at column 1 Xaver Hinterhuber Charts and Charting in Excel 5 June 6th 05 08:24 AM
Excel: Add time to a date and time column? Nik Excel Worksheet Functions 3 April 29th 05 02:52 AM
How do I reference every "n" cell in a column in Excel? Alma Excel Worksheet Functions 2 March 22nd 05 06:19 PM


All times are GMT +1. The time now is 11:17 AM.

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"