cancel
Showing results for 
Search instead for 
Did you mean: 

Show current and previous year line chart

Former Member
0 Kudos

Hi,

My requirement is to show the current and previous year line chart in a single graph.

My source values are like this

2013.01.10 - 20

2013.09.20 - 10...etc

2014.02.28 - 5

2014.04.15 - 10...etc

I need two line in a single chart for 2013 and 2014 values.

Any idea how I can do this?

Thanks in advance.

Arun

View Entire Topic
Former Member
0 Kudos

Hi Arun,

Create Year variable from Date that you have:

Year_Var = =FormatNumber(Year(ToDate([Date];"yyyy.MM.dd"));"####")

Create table using

Year      Date      Amount/Quantity

Right Click on table Turn Into > Line Chart

In Category Axis give

Date

In Value Axis1 give

Amount/Quantity

In Region Color give

Year

I think it will work for you.

Thanks,

Ankit

Former Member
0 Kudos

No it doesn't work.

I need two lines on a single chart one for 2013 and other for 2014. Is that possible without a 2- axis line chart?

Former Member
0 Kudos

You need to show something on Category Axis and Value Axis in single chart.

On Value Axis you can assign value which is: 5,10,15,20. But what you want to show on category axis.

Any dimension you have to use on categ. axis either month or anything.

To show years use color lines.

PFA image.

Former Member
0 Kudos

Ok it works, i added month in the category axis.

Thanks,