Skip to content

serie name on bubble chart, category axis position, leader lines on bubble chart#1100

Merged
gitbrent merged 1 commit intogitbrent:masterfrom
spinozapps:feature/show-ser-name-cat-axis-cross-at
Aug 6, 2022
Merged

serie name on bubble chart, category axis position, leader lines on bubble chart#1100
gitbrent merged 1 commit intogitbrent:masterfrom
spinozapps:feature/show-ser-name-cat-axis-cross-at

Conversation

@mathbruyen
Copy link
Contributor

Ability to add serie name to bubble chart

The goal is to actually display a label aside each bubble. Adding a label per bubble requires generating a lot of XML: adding a new column with label as data, and data references to these labels.

Adding serie name is much easier, only setting a flag. The trick is then to create one serie per bubble: X axis contains the positions of all bubbles, then each serie contains a single value. It also allows setting the color for each bubble, again without complex generation.

X Axis Serie 1 Size 1 Serie 2 Size 2 Serie 3 Size 3
1.5 2.5 100
2 1.2 50
2.3 3.2 75

Category axis position

Values axis can be set at an arbitrary position using valAxisCrossesAt, but category axis could not be positioned the same way. Add catAxisCrossesAt that behaves the same way to set it, and preserve previous behaviour when not set.

Leader lines on bubble chart

Leader lines could be enabled by a property, but were not enabled on bubble chart. Those are not displayed by default as Powerpoint judges that when the label is at its default position, then leader line is redundant. But if the label is moved, leader line appears.

Result

image

@mathbruyen mathbruyen force-pushed the feature/show-ser-name-cat-axis-cross-at branch from e3c3f28 to ef0f238 Compare April 15, 2022 14:48
@gitbrent gitbrent self-assigned this May 25, 2022
@gitbrent gitbrent modified the milestone: 3.11.0 May 25, 2022
gitbrent added a commit that referenced this pull request Jul 26, 2022
@gitbrent gitbrent mentioned this pull request Aug 6, 2022
@gitbrent gitbrent merged commit e39179a into gitbrent:master Aug 6, 2022
@gitbrent
Copy link
Owner

gitbrent commented Aug 6, 2022

Thanks Mathieu!

gitbrent added a commit that referenced this pull request Aug 6, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants