+ Reply to Thread
Results 1 to 1 of 1

Is It Possible To Make Graphs Of My Own?

  1. #1
    all4excel
    Guest

    Cool Is It Possible To Make Graphs Of My Own?

    i have a scenario , large amount of data for graph , and all the data is not in maths (i.e. figures ).
    To give an idea im doing an analysis for the copmpany to hire for my BPO Operations, now i have the price quotations in $ and the workforce, the location , now what i want is to have a different colour for each location (i.e BAR) however that not possible as name of city is not a math.
    Any suggestions...
    how do i go about it?

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by all4excel
    i have a scenario , large amount of data for graph , and all the data is not in maths (i.e. figures ).
    To give an idea im doing an analysis for the copmpany to hire for my BPO Operations, now i have the price quotations in $ and the workforce, the location , now what i want is to have a different colour for each location (i.e BAR) however that not possible as name of city is not a math.
    Any suggestions...
    how do i go about it?
    Hi,

    with the city in column A, the value in column B select the data for both columns and Insert Chart, Bar chart.

    Then rightmouse the data series and 'Format Data Series', under Options select different colour for each point.

    hth
    ---
    Si fractum non sit, noli id reficere.

  3. #3
    all4excel
    Guest

    I Want My Own Graphs Not Ms-excel Chart Wizard

    Thanx For The Help However Im Sorry Tht I Wasnt Clear I Wnt To Mkae Graphs Programttically Not Using Ms-excel Chart Wizard

+ 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