+ Reply to Thread
Results 1 to 2 of 2

Chart color in Excel 2007 compare to excel 2016

  1. #1
    Registered User
    Join Date
    11-16-2016
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    35

    Chart color in Excel 2007 compare to excel 2016

    Hello all,

    The code blow works for excel 2016, but for excel 2007 the color comands gives the wrong colors. How should I write this code in excel 2007?

    Cheers Raffe

    Dim R
    Dim G
    Dim B

    R = 127
    R = 127
    R = 127

    ActiveChart.SeriesCollection(i).Name = "Test"
    ActiveChart.SeriesCollection(i).Format.Line.ForeColor.RGB = RGB(R, G, B)
    ActiveChart.SeriesCollection(i).Format.Line.Style = msoLineSingle
    ActiveChart.SeriesCollection(i).Format.Line.DashStyle = xlContinuous
    ActiveChart.SeriesCollection(i).Format.Line.Weight = 2
    ActiveChart.SeriesCollection(i).MarkerBackgroundColor = RGB(R, G, B)
    ActiveChart.SeriesCollection(i).MarkerForegroundColor = RGB(R, G, B)
    ActiveChart.SeriesCollection(i).MarkerSize = 4

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Chart color in Excel 2007 compare to excel 2016

    Please use [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags when posting code.

    Have you mistyped this section:
    Please Login or Register  to view this content.
    Changing it to
    Please Login or Register  to view this content.
    might help
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. Excel 2016 Bar chart with Total and Count
    By milindsaraswala in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-05-2016, 01:35 AM
  2. Replies: 24
    Last Post: 08-24-2016, 05:10 AM
  3. Replies: 2
    Last Post: 05-24-2016, 10:43 PM
  4. [SOLVED] Excel 2016 getting Freeze during inserting chart
    By anu0512 in forum Excel General
    Replies: 5
    Last Post: 04-18-2016, 08:07 AM
  5. Replies: 4
    Last Post: 11-05-2012, 07:15 AM
  6. Fill color between two XY line in chart in excel 2007
    By tomopaljk in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-31-2011, 06:26 PM
  7. VB6 & Excel 2007: Setting Color of Plot Line in Chart
    By unhappy_camper in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-05-2009, 02:02 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1