Results 1 to 11 of 11
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: graphics with colored line... (2000)

    You write that you want to use "the summ of value in column SERV", but that column contains text values, so you cannot sum them. Do you want to count the number of cells with "AN" etc.?

  2. #2
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: graphics with colored line... (2000)

    Sorry Hans... naturally COUNT, i am stupid;-(
    Buit in other case have you understand my qst? i hope Yes...

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: graphics with colored line... (2000)

    See the attached version. I created a table in TABELLA with formulas to count the values, and then created a chart based on the table.
    You can double-click the lines in the chart to change their colors.
    Attached Files Attached Files

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: graphics with colored line... (2000)

    NO WORDS!!!!
    only you!
    Tks.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: graphics with colored line... (2000)

    To use only one chart:

    Private Sub UpdateChart()
    Dim CurrentChart As Chart
    Set CurrentChart = Sheets("TABELLA").ChartObjects(1).Chart
    CurrentChart.SeriesCollection(1).Values = _
    Sheets("TABELLA").Range("G2:G22").Offset(0, ChartNum)
    CurrentChart.ChartTitle.Text = _
    Sheets("TABELLA").Range("G1").Offset(0, ChartNum)
    CurrentChart.Parent.Width = 550
    CurrentChart.Parent.Height = 300
    Fname = ThisWorkbook.Path & Application.PathSeparator & "temp.gif"
    CurrentChart.Export Filename:=Fname, FilterName:="GIF"
    Image1.Picture = LoadPicture(Fname)
    End Sub

    To change the alignment of the axis labels:
    - Double click the axis or one of its labels.
    - Activate the Aligment tab (the last tab in the Format Axis dialog).
    - Specify the desired alignment by entering an angle in the Degrees box or by dragging the line in the graphic above the box.

  6. #6
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: graphics with colored line... (2000)

    wow!!!!!!!!!!!!!
    wORK FINE. Tks.
    only one...
    But why during scrool whith AVANTI & INDIETRO flashing a pop windows with the path of saving gif.... Nort is possible to suppress it...???


    i have insert from code the line above but the code flashing always.
    Application.ScreenUpdating = False
    Application.EnableEvents = False

    ..... code to save gif

    Application.ScreenUpdating = True
    Application.EnableEvents = True

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: graphics with colored line... (2000)

    Application.ScreenUpdating and Application.EnableEvents apply to the Excel workbook, not to the "pop windows". I don't know if you can suppress those, I don't see them on my PC.

  8. #8
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    graphics with colored line... (2000)

    How to make a sample graphic with five lines based the summ of value in column SERV. ....
    Exaple or rappresentation is in TABELLA.
    To distinquish each line use a diffrent color of line for example red for LUSTSTP , green for LUST10C....

  9. #9
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: graphics with colored line... (2000)

    To learn on grahics...

    prob:

    instead to create 5 single chart for each LUSTXXXX is possible to use one standard and fill based scroll in form (AVANTI & INDIETRO)?
    and
    why the value of column G are in oblique and not in vertical?

    to test start usaerform in project.

    tks a susual

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: graphics with colored line... (2000)

    Since you have removed the attachments from this thread, as you have done in the past from previous posts, I will no longer post replies to your questions.

  11. #11
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: graphics with colored line... (2000)

    Yes. delete to update with a new ver...

Posting Permissions

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