column graphs with lines
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: column graphs with lines

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need to create a graph that consists of column graphs along with 4 lines. The data will be the column graph and the lines should be a straight line indicating the the percentage factor. There are 4 different percentages (cost growth factors). There are a total of 10 columns of data. The first 2 columns are the name of the projects and work order numbers which shows down below the graph. I have 4 columns with fomulas that is the actual data and 4 columns with the percentages.

    I can get the column graphs to work (with the job number and work order number under the columns), but can't get the straight lines showing the percentages. The percentages are like .030, 0.072 etc. I also seem to have trouble getting the graph range to accept all 10 columns. It also seems to leave 2 columns off the range even though it shows it has it.

    thank you.

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Posts
    128
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you create the entire chart as column type (including percentages) finish the chart and right click on the percentages columns and change chart type to line

    Hope this helps

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I am specifying what data columns to grab for the chart and its grabbing extra data columns and don't know why (no apparent reason and incorporating them into the graph.
    How do we stop it from grabbing the extra data? Also the percentages are too tiny to show up on the grap how do I click on them to change it.
    thanks.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com