Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Charts Post Reply Post New Topic
Author Message
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Topic: Charts
    Posted: 28 Jan 2015 at 9:27am
Help! I know nothing about charts and I'm trying to do a line chart but none of my data is showing up. If it does, it is all stacked on top of each other in the middle of the chart. I chose "Line Chart" looks simple but it is not working. I was able to create a bar chart but really want the line chart. Does anyone have any idea why this isn't working ? All i want is the data for each month to show up as a line.

   
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Jan 2015 at 9:32am
what do you have set under the Data tab?
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 28 Jan 2015 at 9:36am
usage month 1, usage month 2, etc.
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 28 Jan 2015 at 9:45am
please bear with me, i am very new at this!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Jan 2015 at 9:47am
ahhh.
you created formula summarizing each month on one row of data in your data set and are placing these as the show values?
Generally speaking what you want to do would be to
1- use your date field as the "On Change of" field value set to 'per month' - that will create your X axis showing a grouped month of the values in your data set
2 -then add the usage field as as sum in the 'Show value' - this would then create the y axis and plot your points for the line 


Edited by DBlank - 28 Jan 2015 at 9:47am
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 28 Jan 2015 at 10:26am
thanks, i think i'm getting there! got the line now. :)   now i'm trying to get a trendline.   Thanks so much for your help!! :)
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.012 seconds.