Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, All
I have a chart wit about 1000 values (also see attachment)
Dimension of the chart is not numeric and most of the chart line lies beyond chart, when i resize i can see more of the line.
the chart before resize
chart after resize (more of the chart line appears)
How to make the whole chart line lie within the chart?
i've tried to make calculated dimension, but i cannot make it (there is a field by which we may filter values shown in the graph)
Here is the Trick....
Bar Chart has option called "Show Allbars" under Presentation..this will eanbles to see all data points even though if you have lot of em...
So convert your line chart to BAR and then select that option and change your chart to Line again...
Only this here is that "Dimension labels doesnt make sence here..since there is no much space to show all of them in the x-axis. so some of them wont show up...But that's ok...
Some thing like if you have data 1 to 10000.
axis will show 1 5 10 15...etc..
Phani
Is it possible at all to see all values?
i chehked and uncheked all checkboxes in many combinations, but achieved nothing
help me with some idea
thanks
Here is the Trick....
Bar Chart has option called "Show Allbars" under Presentation..this will eanbles to see all data points even though if you have lot of em...
So convert your line chart to BAR and then select that option and change your chart to Line again...
Only this here is that "Dimension labels doesnt make sence here..since there is no much space to show all of them in the x-axis. so some of them wont show up...But that's ok...
Some thing like if you have data 1 to 10000.
axis will show 1 5 10 15...etc..
Phani
It is a problem with so many (1,000) dimension values like this.
You can use a horizontal scroll (Presentation tab, Chart scrolling, X-axis scroll bar).
You can reduce font size for your Dimension, or in your case, just get ride of it completely (un-check Show Legend on Dimension tab).
--
Phaneendra Kunche - thanks for tip. I didn't consider setting as a bar, then flipping back to line. Good to know.
Phani, Thank you for your answer, it solves my problem
Donald, Thank you for helpful answer, it can be used in future