LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ira Ira is offline
external usenet poster
 
Posts: 18
Default How do I use a single cell value to chart a horizontal line in Exc

Background: I am making a chart where monthly expenses are represented by
vertical bars and the monthly budget is a constant, for the entire year,
which is represented by a horizontal line. If a vertical bar for a particular
month rises above the horizontal budget line then I have exceeded my budget
for that month.

What I can do: I can create this chart if I use a monthly budget row where
each cell in the row has the same value.

What I want to do: To keep my spreadsheet manageable, I want to have the
monthly budget specified by a single cell, rather than an entire row, because
it is a constant for the entire yerar.
 
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
Add line to horizontal bar chart Hrafn Charts and Charting in Excel 1 July 21st 06 12:37 PM
Adding a horizontal line to a stock chart wittmaennle Charts and Charting in Excel 3 April 21st 06 08:15 AM
Insert horizontal line/single cell in Excel? CLM Excel Discussion (Misc queries) 1 January 10th 06 09:09 PM
Horizontal Line Chart Volsfan Charts and Charting in Excel 0 September 8th 05 12:44 PM
chart displaying horizontal line for zero data [email protected] New Users to Excel 3 February 1st 05 08:22 PM


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