LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Why Color Flled Data Series on Line Chart Slants

I have a modified line chart showing cumulative product cost over a twelve
month period. The x-axis shows each month, and the data line moves right and
up increasing with the cumulative total for the months. Right now, the first
six months are actual and second six months are projected. Each side is
color filled (using Format Data Series Fill Effects) and there is a vertical
line showing the separation. For some reason the color fill and vertical
line are slanting, indicating different month points between the data line
and the x axis. Any idea what might be causing this and/or how to fit it?
 
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
Combination chart: primary data labels obscure line series on secondary axis Uhl Charts and Charting in Excel 3 December 12th 06 08:52 PM
macro for fixed color lines in line chart based on series name sm Charts and Charting in Excel 1 November 13th 06 09:31 AM
Why does Excel line chart cut off my data series? snowbound Charts and Charting in Excel 4 August 2nd 06 12:19 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM
Refreshing pivot makes second data series line disappear from chart !!! WhytheQ Excel Discussion (Misc queries) 4 July 4th 06 01:28 PM


All times are GMT +1. The time now is 02:26 PM.

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"