FG

Changing data series line weights in Excel chart (many at once)

Fresh3 days ago
Mar 15, 202643970 views
Confidence Score0%
0%

Problem

Is there a way to edit the weight of all lines at once on an Excel line chart? I have a graph with about 50 data series on it, and it's too much to go through all of them and change the weights individually, and it's hard to see the data if the lines were thinner, it'd be a bit easier). I can't see…

Error Output

Sub onepxlines()
        With Selection
            MsgBox ("Selection: " & TypeName(Selection))
            If TypeName(Selection) = "ChartArea" The…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Changing data series line weights in Excel chart (many at once)

Low Risk

Probably easiest to write a quick macro, somthing like

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment