+ Reply to Thread
Results 1 to 6 of 6

Checkbox disappear lines n chart?

  1. #1
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    Checkbox disappear lines n chart?

    I have a chart with allot of lines. Not all the lines are relevant all the time it depends on the situation.
    On the internet i find this.

    I changes the name of the chart and the number of the i's. But the macro still not finding the name of the chart. The title of the chart is NTU41 but is this the same as a chart name?


    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    Re: Checkbox disappear lines n chart?

    I find it. But next problem. When i check or uncheck a box the layout of the chart can be changes even if the sheet is protected. That is not going to end well. Is there a solution?

  3. #3
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    Re: Checkbox disappear lines n chart?

    Second question. The bars in the chart can not be checked or unchecked. Because of the macro is referring to lines. What is the command for the bars?

    I have 2 charts in one sheet. Therefor i made unother macro

    Please Login or Register  to view this content.

    As you van see the same except de i are different. But when i unchecked or check a box i got a error that

    ActiveChart.SeriesCollection(i).Format.Line.Visible = msoTrue is a invalid parameter
    Last edited by Frigide; 02-14-2019 at 01:37 PM.

  4. #4
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    Re: Checkbox disappear lines for two charts?

    I made a mess off the question!!

    I have two questions. How can i change this macro for two charts with lines and bars. So filling and lines?
    Chart 1 = Grafiek 1 with 7 boxes 1 to 7
    Chart 2 = Grafiek 2 with 7 boxes 1 to 7

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    Re: Checkbox disappear lines n chart?

    Is it even possible?

  6. #6
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    Re: Checkbox show/hide lines in 2 charts?

    I tried to separate the boxes and the lines without result. The i is corrupt!

    Please Login or Register  to view this content.


    I see the problem but i don't know how to solve it.

    Box 1 to 7 has to trigger ActiveChart.SeriesCollection(i).Format.Line 1 to 7 of grafiek 1
    Box 7 to 14 has to trigger ActiveChart.SeriesCollection(i).Format.Line 1 to 7 of grafiek 2

    But i don't know how to change the second macro to setup the boxes like that.
    I really like the feature because i can see witch line (flow) is causes the problem. Then i can disable the other lines and make a other chart visible to see what is causing the flow drop.

+ 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. [SOLVED] making a checkbox appear and disappear based on a cell's value
    By yoram in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-12-2021, 11:36 PM
  2. Checkbox or radio buttons that make other cells appear or disappear?
    By mjennings1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2014, 12:03 PM
  3. [SOLVED] Making a Checkbox appear and disappear using a drop box selection
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2013, 09:38 AM
  4. Replies: 1
    Last Post: 06-12-2006, 05:35 PM
  5. Replies: 0
    Last Post: 03-15-2006, 12:35 AM
  6. Lines of a cell disappear HELP!
    By pgruening in forum Excel General
    Replies: 2
    Last Post: 09-07-2005, 06:19 PM
  7. [SOLVED] Pie chart data labels and lines disappear
    By Sally Sibthorpe in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-15-2005, 11: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