+ Reply to Thread
Results 1 to 2 of 2

Graphs Without Colored Indicator Boxes

  1. 04-22-2024, 12:40 PM #1
    raemaurer21
    raemaurer21 is offline
    Registered User
    Join Date
    03-08-2024
    Location
    Portland, OR
    MS-Off Ver
    2019
    Posts
    8

    Graphs Without Colored Indicator Boxes

    Hello,

    Several of my graphs don't have the selection highlighted like the example I've attached. I have to go in and manually change the data selection.
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 04-22-2024, 02:15 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,618

    Re: Graphs Without Colored Indicator Boxes

    The data range is only selected because you have selected that particular chart. Select a different chart and a different cell range will be highlighted. You can show the data from the range in the chart itself by:
    Select a chart
    on the Chart Design Menu tab, select "Add chart Element"
    Choose 'Data Table"
    choose "with legend keys"
    Ben Van Johnson
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic graphs over different periods & drop down boxes
    By ConfusedaboutVBA in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-14-2013, 05:28 PM
  2. Graphs and Automatic Text Boxes
    By Mike5055 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-31-2013, 11:47 AM
  3. Message Boxes If the cells are Colored
    By DrNo1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-20-2012, 03:50 PM
  4. Making my drop down boxes populate graphs
    By optimus prime in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-13-2011, 11:50 PM
  5. Can you use Check boxes on graphs?
    By dandavis1 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-26-2010, 10:15 PM
  6. Check boxes for Line graphs
    By dandavis1 in forum Excel General
    Replies: 2
    Last Post: 03-24-2010, 10:25 AM
  7. Charting Problem, Colored Boxes (Picture Included)
    By KPDUF in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-14-2009, 04:03 PM
  8. How to select text boxes that are in graphs
    By AussieExcelUser in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-12-2007, 11:23 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1