How do I create multiple reference lines within the same worksheet? I have 4 measures that are put into a vertical bar chart. As the county filter changes, we want the reference line to show the state total. The state total is different for each measure so I need 4 reference lines - one above each bar.
Although I would rather do it in the worksheet, would this be easier to do once I add the sheet to a dashboard?
It should be as simple as right click on Axis and Add Reference Line.
This will bring up the Add reference line DIalog.
If you can share a workbook I can help you achieve the desired result
A copy of the worksheet I'm using should be attached. We don't want the axis to show in our final draft. If you could actually tell/show me how to do this that would be great. I appreciate the help.
Hey Sara,
I'm unclear on what you want the final product to be. Can you provide some further details?
Cheers,
Walt
We have combined many worksheets into a dashboard to create an interactive dashboard. The data will change based on county, but we want the state line to stay consistent.
In my image above, we want there to be a line above each bar where the state total is. The total is different for each bar, so we can't have just one line. This will allow the audience to easily compare their county with the state level. The state percentages are 42%, 34%, 23%, 21% respectively.
Its difficult to understand what you are trying to do from your attached image.
Do you have a field or calculation for the state total.
if so why can you not add this onto the same chart as a dual axis
If you can provide a workbook or more screen shots of the fields or calculations you currently have.
this will help the community get you to the desired result
Hello,
Please check the below attachment if it is Correct or Helpful for you.
Thanks,
Amar D. Savale
