-
1. Re: Multiple Reference Lines
khalid norat Nov 29, 2016 8:56 AM (in response to Sara Anderson)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
-
2. Re: Multiple Reference Lines
Sara Anderson Nov 29, 2016 9:15 AM (in response to khalid norat)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.
-
poverty level worksheet.twbx 144.3 KB
-
-
3. Re: Multiple Reference Lines
Walt Reed Nov 29, 2016 9:52 AM (in response to Sara Anderson)Hey Sara,
I'm unclear on what you want the final product to be. Can you provide some further details?
Cheers,
Walt
-
4. Re: Multiple Reference Lines
Sara Anderson Nov 29, 2016 10:25 AM (in response to Walt Reed)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.
-
5. Re: Multiple Reference Lines
Walt Reed Nov 29, 2016 11:08 AM (in response to Sara Anderson)What fields do you use to get the state total?
-
6. Re: Multiple Reference Lines
khalid norat Nov 30, 2016 8:48 AM (in response to Sara Anderson)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 -
7. Re: Multiple Reference Lines
Josephine de Guzman Sep 18, 2018 10:01 PM (in response to Sara Anderson)Hi Sara
I have the same scenario. Were you able to find the fix?
-
8. Re: Multiple Reference Lines
amar savale Sep 18, 2018 10:43 PM (in response to Sara Anderson)Hello,
Please check the below attachment if it is Correct or Helpful for you.
Thanks,
Amar D. Savale
-
ReferanceLine_v10.2.twbx 2.1 MB
-