Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting line graphs
I am trying to change the color of one of the gridlines in my line chart (not
all of them). Since I have not seen any sort of formatting option along these lines, I used the autoshapes function to simply add a colored line on top of the desired gridline; however, I want to be able to update/add data for the graph, and still have the colored line stay where its supposed to when the graph changes. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting line graphs
LandmarkValue
Here's a way to do something similar. Plot this data using an Area chart: Fake Real Bob 2 1 Chuck 2 4 Dog 2 3 In this example, the fake series, 2 is where we want the threshold (your colored gridline) The real series will be on top of the fake one. Right click it, and change the chart type to line. Now the line will be drawn over the gridline, which will indicate the threshold. You can set the color of the fake area to none, and change the line to the color you want. It will look similar to your request. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "LandmarkValue" wrote in message ... I am trying to change the color of one of the gridlines in my line chart (not all of them). Since I have not seen any sort of formatting option along these lines, I used the autoshapes function to simply add a colored line on top of the desired gridline; however, I want to be able to update/add data for the graph, and still have the colored line stay where its supposed to when the graph changes. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
For graphs how do i put a line of best fit? | New Users to Excel | |||
How do you select line or columns in "Line-Column on 2 axes" graphs? | Excel Discussion (Misc queries) | |||
Line Graphs - How do I plot N/As? | Charts and Charting in Excel | |||
Q about Line Graphs | Charts and Charting in Excel | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) |