mnieves

Line Chart Grouping To Compare 3 Month Daily Values

Recommended Posts

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.

post-37892-0-67477500-1365949032_thumb.png

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

post-37892-0-46042100-1365949129_thumb.png

this is my settings and data.

post-37892-0-90007800-1365949174_thumb.png

post-37892-0-82377900-1365949195_thumb.png

post-37892-0-40286200-1365949225_thumb.png

any guidance or help is appreciated.

Thanks

Share this post


Link to post
Share on other sites

Hi,

 

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

 

post-1758-0-90657400-1366089849_thumb.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.

 

 

 

 

Share this post


Link to post
Share on other sites

Hi,

 

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

 

attachicon.gifimage.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:

post-37892-0-30776000-1366121120_thumb.png

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

Share this post


Link to post
Share on other sites

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.

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