Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2022, 04:04 AM
nuublior nuublior is offline Is it possible to make a 'set line' through a column graphic? Windows 10 Is it possible to make a 'set line' through a column graphic? Office 2021
Novice
Is it possible to make a 'set line' through a column graphic?
 
Join Date: May 2022
Posts: 1
nuublior is on a distinguished road
Default Is it possible to make a 'set line' through a column graphic?


Yo.

Just an inexperienced excel user playing around trying to track my sleep and make a graph out of it. So I have made this test graph



I was just wondering if it was possible for me to make my own line through the column chart, like if I want to sleep 8 hours, and that is the target, is it possible to put a bar going through the graph with 8 hours?



For example like I have done here, this is done manually by using a 'shape' in excel. But is it possible to do it automatically through the chart program or no?
Reply With Quote
  #2  
Old 05-29-2022, 12:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Is it possible to make a 'set line' through a column graphic? Windows 7 64bit Is it possible to make a 'set line' through a column graphic? Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

You'll find solutions at How to add a line in Excel graph: average line, benchmark, etc. - Ablebits.com
or at https://www.contextures.com/linecolu...tionchart.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to make a 'set line' through a column graphic? How to make left most column and top most row visible when i scroll kcvinu Excel 3 01-19-2015 07:32 AM
insert text in freeform graphic (make it a textbox) fzr Word 2 09-03-2014 05:54 AM
Is it possible to make a 'set line' through a column graphic? Automatically enter date into a column and make that column read only Mr Davo Excel 1 10-29-2012 01:07 AM
Is it possible to make a 'set line' through a column graphic? Use macro to place line style around graphic AdvanceTheMan Word VBA 1 04-20-2012 08:18 PM
Make row in one sheet equal column of another hypertyper Excel 6 01-31-2012 03:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft