brightside/Weather-Generator
1
0
Fork 0
Code Issues 10 Pull Requests Actions Packages Projects Releases Wiki Activity

Improvement: simplify chart legend #6

New Issue
Open
opened 2025-08-13 21:45:03 +00:00 by brightside · 0 comments
brightside commented 2025-08-13 21:45:03 +00:00
Owner
Copy Link

Currently, macro scans all sheets for those with word "Monthly" in them (PWS Monthly, TMY Monthly, etc), and then creates separate tables summarizing all columns from each sheet that contain specified key words (Like "Avg Temp"). So, for example, we currently have a table that summarizes Temp, with columns like:

PWS Avg Max Temp
PWS Avg Temp
PWS Avg Min Temp
TMY Avg Max Temp
TMY Avg Temp
TMY Avg Min Temp

A macro then creates charts from each of those tables.

Currently, the legends in those charts list every data series like so:

PWS Avg Max Temp (solid red)
PWS Avg Temp (solid yellow)
PWS Avg Min Temp (solid blue)
TMY Avg Max Tempt (dashed red)
TMY Avg Temp (dashed yellow)
TMY Avg Min Temp (dashed blue)

Instead, I want the legend specify each source sheet's line style:

PWS (solid)
TMY (dashed)
...

and then specify color per series type

Avg Max Temp (red)
Avg Temp (yellow)
Avg Min Temp (blue)

Currently, macro scans all sheets for those with word "Monthly" in them (PWS Monthly, TMY Monthly, etc), and then creates separate tables summarizing all columns from each sheet that contain specified key words (Like "Avg Temp"). So, for example, we currently have a table that summarizes Temp, with columns like: PWS Avg Max Temp PWS Avg Temp PWS Avg Min Temp TMY Avg Max Temp TMY Avg Temp TMY Avg Min Temp A macro then creates charts from each of those tables. Currently, the legends in those charts list every data series like so: PWS Avg Max Temp (solid red) PWS Avg Temp (solid yellow) PWS Avg Min Temp (solid blue) TMY Avg Max Tempt (dashed red) TMY Avg Temp (dashed yellow) TMY Avg Min Temp (dashed blue) Instead, I want the legend specify each source sheet's line style: PWS (solid) TMY (dashed) ... and then specify color per series type Avg Max Temp (red) Avg Temp (yellow) Avg Min Temp (blue)
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
brightside
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: brightside/Weather-Generator#6
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?