Sign in to follow this  

Column 2D

Recommended Posts

Hi folks,


I was wondering if there is any way we could show a threshold value (something like value to achieve) in Column 2D chart. I know one way to do it is with Trendlines. I am displaying monthly data with x-axis depicting the months.




Different months have different goals(value to achieve) and a single trendline wont help in this case. Is there any chart that could help me out?

Share this post

Link to post
Share on other sites
Guest Rajroop

Hello :),




Apologies for the delay in the reply.




Could try using the combinational chart to achieve this?






The idea is as follows:


Use columns to show the the value achieved in a month, which would refer to the primary axis and a line above it to indicate the month-wise Threshold value, which would refer to the secondary axis.




I hope this helps. :)

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this