Current position:  Home > Default > Chart/Columns labels

Chart/Columns labels

Time:November 30
Advertisement
I am building a Column chart I'm not sure what its called but its where you add different series together to make a column chart (this option is second from the top and on the left side in the charts selector). I would call it a additive column chart. What I want to do is add a label to the chart. However, I don't want the labels of the individual series but the sum of the series. I would like this number to appear at the top of the Chart Column.
So for example if my data for a particular column says:
Canada 10
US 5
Other 3
I want the number 18 to be displayed in the chart. It is an additive column of course so why can't I show the total?
I just want to show the total somehow as a number on the chart.
Thank you.
Advertisement
That chart is called a stacked bar chart. I don't know how to do what you want automatically but I'll try a few things out and report back (unless someone else answers before I figure it out). You always have the option of putting text boxes on the chart with the numbers you want.
EDIT: Here's an idea that works but it kind of a pain. The advantage it has over individual text boxes is that it recalculates the sums and puts them in the correct place automatically.
1. Create another column of data in your table that is the sum you want.
2. Plot a bar chart of that column. Ensure the min and max on the Y axis are the same as your first chart. It would be best to set these in each chart so you can ensure they will never be different.
3. Show value labels. This should show your sums.
4. Hide all the other elements of this chart. No axis, no gridlines, no Y axis values, no X axis categories, etc.
5. Set the fill color of the chart and the bars to none (in the Graphic Inspector)
6. Slide it overtop of your first chart.
7. Reposition/resize the chart until everything lines up and looks good.
For many operations, such as adding another row of data or changing values in your table, this should work out fine with no further adjustments required. For adding new rows of data to the chart, you will have to do it for both charts instead of just one.
Message was edited by: Badunit

Bi publisher report, data table, column label displays last character

2015-10-11

Hello all, I have created various reports on BI Publisher (win2008 R2 64bit 11g (.1.1.5) version). After altering some access rights, all the reports that include data tables display only the last character of the column label. All the column data is

How to print Column Labels on each print page of an ALV report

2015-10-11

Hi, I have an ALV report which is of 10 print pages. I need to print Column Labels on each print page. How it is possible. Plz write the solution NarendraHi Narendra try this code. reward pts if help. Deepanker. *& Report  ZDEMO_ALVGRID_EDIT         

How can i  change the column label text in a alv table display

2015-10-11

how can i change the column label text in a alv table display?? A similar kinda of question was posted previuosly where the requirement was the label text was needed and following below code was given as solution : <i>*  declare column, settings, he

Printing double line in Column label Box/Table Line Type of smartform

2015-10-11

Hi, In MAIN window, in ITEM table, the header box, (where column labels are printed), one double lines r printing!! it looks like (not exactly) instead of single line (________) its printing double lines (======), so, pls. let me know, Wht culd be th

Chart Legend Labels

2015-10-11

Hi all, It's extremely annoying to have to go thru all chart legend label displays and rename them to something else other than the formula. For example, I have a Sum of @Formula that's displaying and in order to change that, I have to go into every

How do I rotate chart axis labels?

2015-10-11

Trying to rotaet chart axis labels for the x-axis, but would like to know the same for the y-axis too. Know the solution for a text box, but doesn't seem to work for the axis labels.Hi Martin, The solution is the same for X and Y labels. Select the l

Hiding row and column labels

-0001-11-30

You can format a table so that it looks just like a form - e.g. give it a background color, shadow, etc. Looks very nice. However, whenever you click on a cell, the row and column the row and column labels suddenly appear, and the visual illusion of

Crystal Reports 2008 Pie Chart Data Labels

-0001-11-30

Hi, I've been trying to figure out why I cannot get the option to put pie chart data labels in the center of each slice.  There's an option to place them there, but everytime I select it, the graph reverts to putting the data labels on the outside wi

How to get text from column  labels in pivot using javascript?

-0001-11-30

Hi, is it possible to get text from column labels in pivot using javascript? How?You don't get a response from a URLRequest, you get the response from a URLLoader: View this sample page for URLRequest and URLLoader and I think it'll make more sense t

How to display PIE chart Axis label horizontally?

-0001-11-30

Hi Currently my PIE chart axis label is displying in 2 lines. How make it to display in one line? Thank youhi, For Pie chart there will be no X-axis or Y-axis terms generally. Label/Text could be one of the following. Title? or Sub Title? or Foot not

Chart Axis: Label Renderer pixel width

-0001-11-30

Am using custom label renderer for Chart Axis labels. CustomLabelRenderer extends label override   public function set data(value:Object):void  if(value is AxisLabel){ dataValue = String(value.text); else{ dataValue = String(value); I would like to g

Please suggest how can we place chart series label evenly in Pie Chart of SSRS 2008

-0001-11-30

Could you please suggest how can we place chart series label value evenly so that it doesnot overlap with each other and user can view the data properly. Please find  the attached  screenshot for the same.Hi SubhadipRoy, As Satish posted, the solutio

Waterfall chart data labels - not rendering in Flash

-0001-11-30

I have a problem with the waterfall charts.  When I turn on the data labels, the charts fail to render in Flash - I get a axis and some garbled legend icons.  If I turn off the waterfall chart data labels, the problem goes away.  Clearly, there is so

How to bind bar chart(columns) to array list object in c# win form

-0001-11-30

how to bind bar chart(columns) to array list  object in c#win formHi Ramesh, Did you want to bind list object to bar chart? I made a simple code to achieve binding list to bar chart. public partial class Form0210 : Form public Form0210() InitializeCo

Manipulating Dashboard Prompt value in Column Labels

-0001-11-30

Guys, I have a bit of strange requirement and I was wondering if anyone resolved this before Users select month value called 06_12 in the prompts, I need to extract 12 out of that and display it in column labels So if 06_12 is selected then my measur

How can I save waveforms w/o time, column labels

-0001-11-30

I am using the AI Acquire Waveforms VI to sample channels simultaneously. I would like to save only the data, without the time, header or column labels. Thanks in advance. Attachments: mch.vi ‏35 KBPut a Get Waveform Component with the Y item selecte

Show Section column labels only once

-0001-11-30

Hello, I have a pivot view with few columns in "SECTION" area of the view. i want the column labels to just show once. Is that possible or should i use different "view". Please help me... Thanks Kirankiran, why are you trying to achiev

Dynamic Column Label

-0001-11-30

I have a dynamic report with REF Cursor query. The SELECT clause is dynamic (different columns are selected, but always the same number of columns). I have a static ref cursor that returns a record (Field1, Field2, .. FieldN) and a dynamic refcursor

Problem in Combo chart columns and line

-0001-11-30

I select chart type is  combo in my vc model  and select data series is columns and line. I define 5 series in the chart. once i deployed the model the output shows the columns are overwrite in stacked position. eg: series 1: 10% series 2: 20% series