Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

cfchart x axis squished compressed

Posted on 2009-04-10
2
Medium Priority
?
395 Views
Last Modified: 2013-12-24
I'm doing a line chart from an oracle query and the x axis is squished that is it doesn't extend to the width of the chart it only goes about halfway did a similiar chart with no problem. Data is from oracle. have tried a number and varchar as the year value (x axis)
<cfchart format="flash" >
 
<cfchartseries query="get_chart" type="line" serieslabel="World Crude Production"
      paintstyle="raise" markerstyle="circle"   >
<cfoutput query="get_chart">
<cfchartdata item="#int_year#" value="#world#" >
</cfoutput>
</cfchartseries>
<cfchartseries
      type="line" serieslabel=" non-OPEC Crude Production"
      paintstyle="raise" markerstyle="circle" >
            <cfoutput query="get_chart">
              <cfchartdata item="#int_year#" value="#nonopec#">
            </cfoutput>
            </cfchartseries>
             <cfchartseries
      type="line" serieslabel=" OPEC Crude Production"
      paintstyle="raise" markerstyle="circle" >
            <cfoutput query="get_chart">
              <cfchartdata item="#int_year#" value="#opec#">
            </cfoutput>
            </cfchartseries>
             <cfchartseries
      type="line" serieslabel="Persian Gulf Crude Production"
      paintstyle="raise" markerstyle="circle" >
            <cfoutput query="get_chart">
              <cfchartdata item="#int_year#" value="#Persiangulfnations#">
            </cfoutput>
            </cfchartseries>
</cfchart>
 
   	INT_YEAR	NONOPEC	OPEC	PERSIANGULFNATIONS	PROD_YEAR	WORLD
1 	1973 	24.679119 	30.999781 	20.668 	1973 	55.6789
2 	1974 	25.01989 	30.6966 	21.282 	1974 	55.71649
3 	1975 	25.73201 	27.096358 	18.934 	1975 	52.82841
4 	1976 	26.722373 	30.622027 	21.514 	1976 	57.3444
5 	1977 	28.43642 	31.2705 	21.725 	1977 	59.70692
6 	1978 	30.360961 	29.796989 	20.606 	1978 	60.15795
7 	1979 	31.73215 	30.942 	21.066 	1979 	62.67415
8 	1980 	32.597563 	26.96 	17.961 	1980 	59.557563
9 	1981 	33.227867 	22.822 	15.245 	1981 	56.049867
10 	1982 	34.3426 	19.111 	12.156 	1982 	53.4536
11 	1983 	35.345591 	17.911 	11.081 	1983 	53.256591
12 	1984 	36.590939 	17.908 	10.784 	1984 	54.498939
13 	1985 	37.273191 	16.693 	9.63 	1985 	53.966191
14 	1986 	37.348612 	18.85 	11.696 	1986 	56.198612
15 	1987 	37.575746 	19.051 	12.103 	1987 	56.626746
16 	1988 	37.613855 	21.078 	13.457 	1988 	58.691855
17 	1989 	36.986246 	22.805 	14.837 	1989 	59.791246
18 	1990 	36.536682 	23.955 	15.278 	1990 	60.491682
19 	1991 	36.113677 	24.073951 	14.741 	1991 	60.187628
20 	1992 	34.869676 	25.245418 	15.96984 	1992 	60.115094
21 	1993 	34.19671 	25.97122 	16.71462 	1993 	60.16793
22 	1994 	34.691346 	26.411223 	16.964334 	1994 	61.102569
23 	1995 	35.342616 	27.042261 	17.207643 	1995 	62.384877
24 	1996 	36.185785 	27.565948 	17.367364 	1996 	63.751733
25 	1997 	36.93155 	28.812086 	18.095036 	1997 	65.743637
26 	1998 	37.080787 	29.884761 	19.336634 	1998 	66.965549
27 	1999 	37.225901 	28.696487 	18.667406 	1999 	65.922388
28 	2000 	38.086685 	30.407949 	19.89231 	2000 	68.494634
29 	2001 	38.602306 	29.498719 	19.098448 	2001 	68.101026
30 	2002 	39.520346 	27.641192 	17.793762 	2002 	67.161538
31 	2003 	40.29861 	29.135865 	19.062811 	2003 	69.434475
32 	2004 	40.989281 	31.503726 	20.787224 	2004 	72.493007
33 	2005 	40.799237 	32.937619 	21.500973 	2005 	73.736856
34 	2006 	40.850499 	32.610337 	21.231904 	2006 	73.460835
35 	2007 	40.832175 	32.173864 	20.671981 	2007 	73.006038
36 	2008 	40.349784 	33.441452 	21.870929 	2008 	73.791236

Open in new window

GraphData.cfm.png
0
Comment
Question by:pwdavismd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
azadisaryev earned 2000 total points
ID: 24182898
it's rather simple, actually - just remove the QUERY attribute from your first <cfchartseries> tag! :)

Azadi
0
 
LVL 1

Author Closing Comment

by:pwdavismd
ID: 31568942
Thank you!
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question