Line Chart Grouping To Compare 3 Month Daily Values

[mnieves]

Hello,

I have a Line Chart to Compare the daily value of the last three months. I have a small issue that i cant resolve, the issue is explain in the images.

 

This is how i want the compare to look and behave like this first image.

And the results im having in my charts until now are this one.

this is my settings and data.

any guidance or help is appreciated.

Thanks

[Rahul Kumar]

Hi,

 

I am afraid the highlighted areas in the image below are not possible to replicate.

 

 

And regarding the chart, please change current chart type to Multiseries > "Multi Series Line 2D" chart instead of "Logarithmic Line". After changing the chart type it'll show the same chart as it is in the original image. And you can also change the anchors/markers for each line plot by going to "Series Customization" > "Anchors" > "Sides".

 

I hope this helps.

 

 

 

 

[mnieves]

Hi,

 

I am afraid the highlighted areas in the image below are not possible to replicate.

 

image.png

 

And regarding the chart, please change current chart type to Multiseries > "Multi Series Line 2D" chart instead of "Logarithmic Line". After changing the chart type it'll show the same chart as it is in the original image. And you can also change the anchors/markers for each line plot by going to "Series Customization" > "Anchors" > "Sides".

 

I hope this helps.

Thanks for your answer.

I need a the same layout without the anchors sides. this is not needed.

 

i want to compare the value of three months daily Value SUM.

side by side to show the difference from month to month.

 

sample:

I just need to remove the all extra 0 values and align all the lines to the left corner.

[Rahul Kumar]

Hi,

 

Sorry, it is not possible to do the same. As data is grouped and the 0 values are coming because there are no data for that period. And regarding the left alignment in Collabion data is grouped by date which means the data is grouped by year, month and day that's why the next series is not at left where as in the original image (chart) the data is grouped by 1,2,3,4,5,6...31 (numeric values) and each series has valid data for these numeric values for example: For category 1 has all the data for each series (Months) "Nov-12: 175", "Dec-12: 155", "Jan-13: 125" hence it is showing the data series starting at left.