MBCS

I have an error with this solution. I'm able to get most of my values to show up correctly. (0.152 --> 15.2%). However, values under 10% do not show up correctly in my chart. If the value is under 10% (.10), the value just shows up on the chart without the scaling and % applied. So 0.031 just shows up on the chart as 0.031 instead of 3.1%.

I also would like to see this feature. I've also seen multiple posts requesting how to do this, but it is currently not supported. If you create this type of chart, some sort of repeating x-axis range, please include the ability to select start/end of the x-axis window. It would be nice to specify the x-axis range for waterfall plots as well. Another way to implement this is related to another request I've seen posted here. If the user can connect to multiple lists to combine them on the same chart, they could accomplish this by connecting multiple times to the same list. Each connection could have different filtering. EX: connection 1 filters for 2014, connection 2 filters for 2015, connection 3 filters for 2016. Hopefully, they could all be displayed only by month. I don't know if this works or not, but it has been very important to our management to view data in terms of comparing it to previous years, quarters, etc. This functionality would be really appreciated. Thanks.

Hello, I'm trying to create a chart showing two series lines. The first would be the Planned Costs (vs. Date) and the second series is the Actual Costs (vs. Date). The problem is that there are large date gaps between data points and I have dates where I don't have values for both series. If a "Actual" cost is between two "Planned" costs, the line is broken for both series. Is there a reason that the lines are not continuous? Is there a way that I can get the lines to not be broken? I've tried grouping the date data by day, but this did not solve my issue. Also, without date grouping, the X-axis does not represent correct spacing for date data. The gaps are always uniform in the data. is there a way to set the x-axis to a date range and have it scale correctly? This didn't seem to work with an X-Y chart either. This seems like it should be a fairly simple problem for this type of program. I've attached example data and a screenshot of the chart that is created. Any help would be greatly appreciated. Best regards. Example Data: Broken Line Chart:

Thank you very much! That solved my issue perfectly. Best regards.

Hello, I’m having a similar issue. I have a list as shown below: (SPData01.jpg) Actual costs will be added at random times. Planned costs will have large date gaps. I’d like to show a line graph showing actual costs and planned costs. I’ve grouped by CostDate (Day) and the lines are interrupted if there is a value from the other series (Cost Type) in between the values for the other series as shown below: (SPDataChart01.jpg) How do I get these lines to not be broken? Thanks