Results 1 to 4 of 4

Thread: Change Color Of Series In A Bar Chart Based On Selection Of DropDowns

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-16-2014, 07:14 PM #1
    mrprofit
    mrprofit is offline
    Member
    Join Date
    Apr 2014
    Posts
    45
    Rep Power
    0

    Change Color Of Series In A Bar Chart Based On Selection Of DropDowns

    I would like to use a dropdown list to run macro to color the bar chart, what is the code to run the dropdown list in D1 and D4 by the color name "Blue" etc, instead of running on E1 & E4 which select the color code.

    and how to color the D1 cell when the content in dropdown list is selected, now it cannot color the cell, only when i run macro from the Run Macro button, it can color
    Attached Files Attached Files
    Last edited by mrprofit; 04-16-2014 at 07:18 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Change Chart Title According To Source Data Selection
    By terrybloome in forum Excel Help
    Replies: 4
    Last Post: 12-02-2013, 03:19 PM
  2. Update Linked ComboBox List Based On Change In Another ComboBox Selection
    By paul_pearson in forum Excel Help
    Replies: 8
    Last Post: 08-17-2013, 04:03 AM
  3. Change Data Series In Chart Using Drop-Down List
    By raybugge in forum Excel Help
    Replies: 2
    Last Post: 07-06-2013, 03:02 PM
  4. Change chart source based on selection in form control list box in excel
    By naveen_itm in forum Excel Help
    Replies: 1
    Last Post: 05-03-2013, 04:41 PM
  5. Color Chart Series VBA
    By Admin in forum Download Center
    Replies: 0
    Last Post: 04-29-2011, 11:26 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