Showing posts with label vertical. Show all posts
Showing posts with label vertical. Show all posts

Wednesday, March 7, 2012

Charts, aligning plot area vertically

Say you have a few charts which you want to align vertically. Both left and
right side of the charts should be at same vertical position. This is
especially important if you have same measurement and scale for the x-axis
for two charts and want to compare values across two diagrams. I have not
found a way to get vertical aligment (yet).
The area for the plot area seems to be determined by the text size needed to
print the y-axis labels. And this is of course dependent on the actual data.
Apparently, the chart component is licensed from www.dundas.com. On that
site, I found a white paper suggesting you can do this using an
AlignWithChartArea property. However, I can't find such in RD. Am I correct
in assuming that this feature is missing from RD?
Any ideas on how to accomplish this?
TIA
Tibor Karaszi
SQL Server MVPYou could make the charts the same size and do the alignment using Layout
toolbar in the Designer (Align Left/Align Right toolbuttons.)
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uzkCwqaiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Say you have a few charts which you want to align vertically. Both left
and
> right side of the charts should be at same vertical position. This is
> especially important if you have same measurement and scale for the x-axis
> for two charts and want to compare values across two diagrams. I have not
> found a way to get vertical aligment (yet).
> The area for the plot area seems to be determined by the text size needed
to
> print the y-axis labels. And this is of course dependent on the actual
data.
> Apparently, the chart component is licensed from www.dundas.com. On that
> site, I found a white paper suggesting you can do this using an
> AlignWithChartArea property. However, I can't find such in RD. Am I
correct
> in assuming that this feature is missing from RD?
> Any ideas on how to accomplish this?
> TIA
> Tibor Karaszi
> SQL Server MVP
>|||Yes, but unfortunately this applies to the control per se. I.e., the Chart Area. What I need to be aligned is
the *Plot Area*.
The size of the plot area seem to be dynamically adjusted based on the text to fill in to the left/right of
the diagram (the part which is in the Chart Area but isn't the Plot Area). This text is drawn from the data,
so I cannot know in advance how long strings it will be.
(This is so I can match scales (vertical lines) across several diagrams.)
Thanks
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:%23f0aB%23eiEHA.2340@.TK2MSFTNGP11.phx.gbl...
> You could make the charts the same size and do the alignment using Layout
> toolbar in the Designer (Align Left/Align Right toolbuttons.)
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uzkCwqaiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Say you have a few charts which you want to align vertically. Both left
> and
> > right side of the charts should be at same vertical position. This is
> > especially important if you have same measurement and scale for the x-axis
> > for two charts and want to compare values across two diagrams. I have not
> > found a way to get vertical aligment (yet).
> >
> > The area for the plot area seems to be determined by the text size needed
> to
> > print the y-axis labels. And this is of course dependent on the actual
> data.
> >
> > Apparently, the chart component is licensed from www.dundas.com. On that
> > site, I found a white paper suggesting you can do this using an
> > AlignWithChartArea property. However, I can't find such in RD. Am I
> correct
> > in assuming that this feature is missing from RD?
> >
> > Any ideas on how to accomplish this?
> >
> > TIA
> > Tibor Karaszi
> > SQL Server MVP
> >
> >
>

Saturday, February 25, 2012

Charts and Graphs Question

I have a chart that has dates list on the x axis in a horizontal fashion. I
would like to change them to be vertical. Can anyone tell me how todo this'
Thanks,Andy,
I don't think you can set it, it seems to be automatic. If the dates
don't fit horizontally, it turns them for you.
The only thing you can affect is the data labels inside the chart area.
Chris
Andy Jones wrote:
> I have a chart that has dates list on the x axis in a horizontal
> fashion. I would like to change them to be vertical. Can anyone tell
> me how todo this'
> Thanks,

Friday, February 24, 2012

Chart problem

I am displaying a chart in crystal report. In this chart/graph on the vertical data axis i have values in the format like 0.00. Now I want to display this value in the format 0:00, i.e. I want to replace the period(.) with a colon.

I am not getting any solution for this. Also I have a field label on the top of the graph which is formula. In this also I have the same problem.

I can get a colon in the Time format but it is disturbing the number system of the graph.

Need a solution.I have a similar problem at the moment; my dates on the horizontal axis are in the standard DD/MM/YYYY format, whereas I need DD.MM.YYYY. I don't think Crystal Graphing tool is powerful enough to do this, but I did find that I could make it appear this way by changing my computer's regional settings.

Hope this is of some help to you.|||Yes, even I think that crystal is not capable of such a thing.
Thanks for your input anyway.

Chart Legend Vertical Sizing

I was able to change the chart legend to show the correct information.
However, the words are too long for the column. How do I
1) Increase the width of the column
2) Make it so the Legend Rows can be taller
I cannot increase the size of the chart, as I have 3 charts side by side
with this issue.
Thank you,
msflinxI have the same problem
"msflinx" wrote:
> I was able to change the chart legend to show the correct information.
> However, the words are too long for the column. How do I
> 1) Increase the width of the column
> 2) Make it so the Legend Rows can be taller
> I cannot increase the size of the chart, as I have 3 charts side by side
> with this issue.
> Thank you,
> msflinx