Forum Discussion
Line Chart
Looking through the image above, my chart shows value for different currencycodes.
Problem is I need the left side space to be removed, i.e., space between X-axis beggining and Europe Only. Same for WorldWide and Axis ending. I want the chart width to be same as I am using now.
One more preoblem is , Is there a way to show Currency Code as data label along with values.
Example in Europe only there is a black bar with value -6.5%. Can it be shown like -6.5% (ABC) where ABC is Currency Code.
I really need a help in this.
Thank You
5 Replies
HI pxg08680,
>>Problem is I need the left side space to be removed
Based on your screenshot, these blank records occupate left part of chart, right?
If this is a case, current clustered column chart not support customize x axis or hide blank category.(these graphs are generated by categories and records, you can't customize it)>>One more preoblem is , Is there a way to show Currency Code as data label along with values.
Current only pie/donut chart support shows detail informations on data label, clustered column chart not support yet.
For your requirement, you can submit this to ideas forum.
Regards,
Xiaoxin Sheng
Anonymous
Thanks for replying.
I tried to CONCATINATE my value column with my Currency Code column. But this all gives me a data type as text. This is working perfectly if I represent them as a table visual but not working for a Line Chart.
Can it be done this way..?
Thank You
Hi pxg08680,
>>I tried to CONCATINATE my value column with my Currency Code column.
Line chart not support use string value in value fields, even if you force drag text column in it, the column will switch to summary mode 'count.
In my opinion, I'd like to suggest you to create new table with filter non-blank records. Then you can use filtered table as the source of line chart.
Regards,
Xiaoxin Sheng
