Forum Discussion
Dynamic goal line in visualization
I am trying to create visualizations for our shipping department which show the summed value of our shipments each month or each week over any given timeline, but want to have the annual plan for eac...
I would use a Line and clustered column chart visualization with your goals as the line or column and the actuals as the other.
Thanks for the reply! What I’m stuck with is that my actuals table is linked to an OBDC that updates itself, and I don’t know how to connect a table I created with the plan in it, and I don’t know how to create a visual that uses more than one unrelated table. Kind of like in excel how I could reference a completely separate set of info on the same chart by using a secondary axis? Can you help me with how I could do that?