Forum Discussion
Line Values with respect to Column series
Hi v-frfei-msft ,
Sorry, I did not mean Data labels. I am talking about the markers in the Line value.
Looking into the figure below, I have four line values i.e., Brand1 Budget, Brand2 Budget, Brand3 Budget and Brand4 Budget. All the Budget markers(Dot) are on the one vertical line.
I want the Budget markers to be on each of the respective brands as shown in below image.
Hi Anonymous,
Unfortunately the combo chart doesn't utilise the Legend field for the line series (like the bar does), so any data points for the line will be placed in the middle of the category it relates to, as shown.
In your visual you're also using a different y-axis for your line series, which does not provide a fair comparison to budget and actual.
If you're looking to provide a fair actual vs. budget comparison, I'd suggest using one of the following custom visuals, as they are optimised for this kind of use case and typically make things much clearer for the reader of your reports:
- Bullet Chart by OKViz
- Power KPI
- Zebra BI (has a license cost, but is the gold standard for visualising financials in this manner)
None of these will do exactly what you're asking for in our image but will hopefully allow you to approach the challenge from a different viewpoint.
Good luck!
Daniel