LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Greg Strong
 
Posts: n/a
Default Program line when charting variances?

Hello All,

Is it possible to program a vertical line when charting variances?

My Y axis is either variance dollars or variance percentage. My X axis is for
what I'm charting variances. For example my X axis could be apple types. In
my data series I sort my Y variable from best to worst, and I'm using a bar
chart. My sample data could be as follows:

Apple Type Variance $
------- -----------
Apple 1 1000
Apple 2 750
Apple 3 100
Apple 4 -400
Apple 5 -750

So I would like to draw a vertical line between Apple 3 and Apple 4. For the
readers of the graph the vertical line becomes a driver. Simply stated I have
my good apples to the left of the line, & the bad apples to the right of the
line.

So if Apple Type represents one product group and there are many product
groups to graph, then there are a lot of graphs to add a vertical line to
manually at the end of each period. Any ideals? TIA!

--
Regards,

Greg Strong
 
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
Formatting lines between data points in a line chart ltanner Charts and Charting in Excel 2 March 13th 05 05:12 AM
Custom charting - Stacked charting with a line Randy Lefferts Charts and Charting in Excel 3 March 3rd 05 03:10 AM
Line and Column Graph Nikki Charts and Charting in Excel 3 February 4th 05 04:42 AM
Is there a program in office to create a line graph? Chris Excel Discussion (Misc queries) 2 January 17th 05 11:38 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM


All times are GMT +1. The time now is 12:48 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"