+ Reply to Thread
Results 1 to 4 of 4

Formatting Data Series In Charts

  1. #1
    Registered User
    Join Date
    02-02-2005
    Location
    London, England
    MS-Off Ver
    Office 2003/2007
    Posts
    14

    Formatting Data Series In Charts

    Good morning everyone,

    I have created a couple of simple line charts that change the data they display based upon a user selection. This means that in my example users can choose to view either Phone or Web performance. I already have the code that changes the charts data source based upon the selection but whenever it changes it reformats to the standard look of the line chart. It may sound picky but i have standard formatting across all the reporting i produce and this is not what i want. Im happy to go with the standard colours that excel is selecting but want to make all of the lines thicker and remove the markers on all of the data series. Is there some way of doing this is code or am i going to have to live with it and hate the look of my report ?

    Hopefully that has adequately explained my problem if not please let me know and ill give more detail.

    Thanks

    EddiesVoicebox

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,182

    Re: Formatting Data Series In Charts

    Try recording a macro of you formatting the chart as required.

    Modify and use that code to reformat you chart.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-02-2005
    Location
    London, England
    MS-Off Ver
    Office 2003/2007
    Posts
    14

    Re: Formatting Data Series In Charts

    Andy, thanks for your reply. For some reason the easiest solution completed escaped me yesterday. I did indeed record it and managed to change it to suit my needs.

    Thanks for the quick response

    EddiesVoicebox

  4. #4
    Registered User
    Join Date
    10-13-2008
    Location
    Australia
    MS-Off Ver
    2007
    Posts
    85

    Re: Formatting Data Series In Charts

    Hi Eddie,

    I was wondering if you could post your VBA code whereby the user selects a certain criteria (out of a data validation list perhaps?) and the source data changes when the macro runs.

    I have been searching for this for a while and would be appreciative if you could share your expertise.

    Cheers,

    Benno

+ 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