+ Reply to Thread
Results 1 to 2 of 2

Stock charts - how to use different colours in chart

  1. #1
    Registered User
    Join Date
    02-07-2013
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    1

    Stock charts - how to use different colours in chart

    Hello, this is my first post so please don't screem at me .

    I want to create stock chart or something like it to see diffrent between products in 2 versions. I post the file like it looks like
    stock_charts.png

    And is it possible to colour the A_ver2 and B_ver 2 in the same colour, for example red? It will be easy to compare them with version 1. If its impossible i can use different charts but it should look like my example.

    Thank for the support
    Last edited by AndrzejSob; 02-07-2013 at 07:08 AM.

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Stock charts - how to use different colours in chart

    Hello
    Try creating a Stacked column chart with 2 series. A 'Base' series using your Min values and a 'Top' series using the values of the Max minus the Min for each Product. Then hide the 'Base' series by removing the fill and border. You can then format the bars whatever colour you wish.

    Hope this helps.
    DBY

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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