+ Reply to Thread
Results 1 to 4 of 4

Highlighting an area of the graph as a target zone

  1. #1
    Registered User
    Join Date
    05-01-2022
    Location
    Calgary, Canada
    MS-Off Ver
    None
    Posts
    1

    Highlighting an area of the graph as a target zone

    I'm using Google sheets.

    I just realized that graphs with a transparent background don't work on mobile. I had made the cells behind my graph to highlight the target zone for the lines in the data, but the don't show on mobile. Is there a way to have the target zones be part of the graph? I moved the graph over on my mobile on order to show how I've made the areas a different color.

    I'm a total spreadsheet novice, so I don't know what's possible, and I'm not very good at describing what I'm trying to accomplish.
    Attached Images Attached Images
    Last edited by lmerr; 05-01-2022 at 03:33 PM.

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Highlighting an area of the graph as a target zone

    Please update your profile with the version of excel you are using (eg. Mac 2019, MS 365) and/or G-Sheets.

    Also... you have not indicated which platform you require troubleshooting for, so please edit you post with that information.

    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Highlighting an area of the graph as a target zone

    you could convert the chart to an image, then remove the chart and insert the transparent image and position and resize the image to suit your needs.

    an alternative would be to use a different type of chart.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Highlighting an area of the graph as a target zone

    It's difficult to say based on your picture and description, but I am guessing you want some variation of the techniques described here: https://peltiertech.com/excel-charts...izontal-bands/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to zoom into a graph by highlighting the area of interest?
    By plumberef in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-31-2020, 02:56 AM
  2. Get Time Zone by looking up Area Code (US Geography only)
    By adi_techmax in forum Excel General
    Replies: 6
    Last Post: 12-14-2019, 04:49 AM
  3. [SOLVED] Making a line graph into a curve graph & finding the area
    By AppleMonster in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-28-2014, 05:37 AM
  4. [SOLVED] Trying to Get MsgBox to come up for Specific value in Target Area
    By cg0789 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-17-2012, 11:42 AM
  5. How to convert phone area-code to state name and time zone
    By NoYouShmoopie in forum Excel General
    Replies: 2
    Last Post: 10-07-2005, 10:05 AM
  6. I need to use area code to determine time zone
    By Dick in forum Excel General
    Replies: 1
    Last Post: 07-11-2005, 01:05 PM
  7. highlighting area used for formula - ajit
    By Div. F-II in forum Excel General
    Replies: 3
    Last Post: 06-09-2005, 07:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1