Chart Macro

The Chart macro allows you to display a chart based on tabular data. When you add the macro to a page, you:

  • supply the data to be charted by the macro as a table in the placeholder of the macro.
  • edit the macro parameters in the Macro Browser to configure the format of the chart.

Screenshot 1: A table of data in the Chart macro placeholder


Screenshot 2: The resulting chart

On this page:

Using the Chart Macro

To add the Chart macro to a page:

  1. Edit the page and use autocomplete to add the Chart macro. (Type '{chart}'.)
  2. Enter your chart data as one or more tables in the body of the macro placeholder. (See the screenshot above.)
  3. Click the macro placeholder and choose Edit.
  4. Select a chart type using the Type parameter (see below).
  5. Choose other parameter settings in the macro browser, as described below.
  6. Click Refresh in the 'Preview' area, to check that the chart appears as you expect.
  7. Click Save to add the chart to your page.
  8. Click Save again when you are ready to save the page.

Parameters

Chart Type Parameters

These parameters determine the type of chart to display and the way the chart looks.

Parameter Default Description
Type pie

The type of chart to display. XY charts have numerical x- and y-axes. The x values may optionally be time-based (see the Time Series parameter).

Standard — pie, bar, line, area

XY Plots — xyArea, xyBar, xyLine, xyStep, xyStepArea, scatter, timeSeries

Other — gantt

Display Orientation vertical

Applies to area, bar and line charts.

    • vertical — y-axis is vertical
    • horizontal — x-axis is vertical
Show in 3D false

Applies to area, bar and line charts.

Stacked Values false Applies to area and bar charts.
Show shapes true Applies to line charts. Shapes are shown at each data point.
Opacity
  • 75 percent for 3D charts
  • 50 percent for non-stacked area charts
  • 100 percent for all other charts
A percentage value between 0 (transparent) and 100 (opaque) that determines how opaque the foreground areas and bars are.

Display Control Parameters

Parameter Default Description
Width 300 The width of the chart in pixels.
Height 300 The height of the chart in pixels.
Display rendered data false

Sets whether to display the rendered body of the macro (usually the data tables). By default, the chart data table isn't rendered.

    • before — the data are displayed before the chart.
    • after — the data are displayed after the chart.
Image format png

The image format to be used for the chart.

    • png
    • jpg

Title and Label Parameters

Parameter Default Description
Chart Title none The title of the chart.
Chart Subtitle none A subtitle for the chart, using a smaller font than for Title.
Horizontal-axis Label none The label for the x-axis (domain).
Vertical-axis Label none The label for the y-axis (range).
Show Legend true Show a legend or key.

Data Specification Parameters

The data for the chart is taken from tables found when the macro body is rendered. These options control how this data is interpreted. By default, numeric and date values are interpreted according to the Confluence global default language (locale) formats. If conversion fails, other languages defined in Confluence will be tried. Additional conversion options can be specified using the parameters below.

Parameter Default Description
Tables all first level tables Comma separated list of table ids and/or table numbers (starting at 1) contained within the body of the macro that will be used as the data for the chart. If data tables are embedded in other tables, then table selection will be required. This occurs when more complex formatting is done (for example using section and column macros).
Columns all columns Comma separated list of column labels and/or column titles and/or column numbers for tables used for chart data. This applies to all tables processed. Columns are enumerated starting at 1. Column label is the text for the column in the header row. Column title is the (html) title attribute for the column in the header row.
Content Orientation horizontal
    • vertical — data table columns will be interpreted as series.
    • horizontal — data tables rows will be interpreted as series.
Time Series false
    • true — the x values in an XY plot will be treated as time series data and so will be converted according to date formats.
Date format Confluence language defined date formats For time series data, the date format allows for additional customization of the conversion of data to date values. If a Date format is specified, it will be the first format used to interpret date values. Specify a format that matches the time series data. See simple date format.
Time Period Day The time period for time series data. Defines the granularity of how the data is interpreted. Valid values are: Millisecond, Second, Minute, Hour, Day, Week, Month, Quarter, Year.
Language none Use in combination with the Country parameter to form a locale. These additional number and date formats will be used for data conversion before the default languages.
Valid values are 2 character ISO 639-1 alpha-2 codes.
Country none Use in combination with the Language parameter to form a locale. Valid values are 2 character ISO 3166 codes.
Forgive true
    • true — the macro tries to convert numeric and date values that do not totally match any of the default or user-specified formats.
    • false — enforce strict data format. Data format errors will cause the chart to not be produced.

Colour Parameters

Colours are specified using hexadecimal notation or HTML colour names.

Parameter Default Description
Background Colour White Background of the chart.
Border Colour no border Border around the chart.
Colours   Comma-separated list of colours used to customise category, sections, and series colours.

Axis Parameters

Depending on the chart type, the range and domain axis may be customised. These values are automatically generated based on the data but can be overridden by specifying one or more more of these parameters.

Parameter Default Description
Range Minimum Value none Range axis lower bound.
Range Maximum Value none Range axis upper bound.
Range Axis Tick Unit none Range axis units between axis tick marks.
Range Axis Label Angle none Angle for the range axis label in degrees.
Domain Axis Lower Bound none Only applies to XY plots. Domain axis lower bound. For a date axis, this value must be expressed in the date format specified by the Date format parameter.
Domain Axis Upper Bound none Only applies to XY plots. Domain axis upper bound. For a date axis, this value must be expressed in the date format specified by the Date format parameter.
Domain Axis Tick Unit none Only applies to XY plots. Domain axis units between axis tick marks. For a date axis, this value represents a count of the units specified in the Time Period parameter. The Time Period unit can be overridden by specifying a trailing character: y (years), M (months), d (days), h (hours), m (minutes), s (seconds), u (milliseconds).
Domain Axis Label Angle  none Only applies to XY plots. The angle for the domain axis label, in degrees. 
Category Label Position  none

Placement of the axis label text for categories.

    • up45 — 45 degrees going upward
    • up90 — 90 degrees going upward
    • down45 — 45 degrees going downward
    • down90 — 90 degrees going downward
Date Tick Mark Position  start

Placement of the date tick mark.

    • start — tick mark is at the start of the date period.
    • middle — tick mark is in the middle of the date period.
    • end — tick mark is at the end of the date period.

Pie Chart Parameters

Parameter Default Description
Pie Section Label Show only the pie section key value Format for how pie section labels are displayed. The format uses a string with special replacement variables:
    • %0% is replaced by the pie section key.
    • %1% is replaced by the pie section numeric value.
    • %2% is replaced by the pie section percent value.

Example 1: "%0% = %1%" would display something like "Independent = 20"
Example 2: "%0% (%2%)" would display something like "Independent (20%)"

Pie Section Explode No exploded sections Comma separated list of pie keys that are to be shown exploded. Note: requires jFreeChart version 1.0.3 or higher.

Attachment Parameters

These are advanced options that can be used for chart versioning, to enable automation and to improve performance. Use these options carefully! Normally, the chart image is regenerated each time the page is displayed. These options allow for the generated image to be saved as an attachment and have subsequent access re-use the attachment. This can be useful especially when combined with the Cache Pluginto improve performance. Depending on the options chosen, chart images can be versioned for historical purposes.

Parameter Default Description
Attachment none The name and location with which the chart image will be saved as an attachment. The user must be authorised to add attachments to the page specified.
    • ^attachmentName.png — the chart is saved as an attachment to the current page.
    • page^attachmentName.png — the chart is saved as an attachment to the page name provided.
    • space:page^attachmentName.png — the chart is saved as an attachment to the page name provided in the space indicated.
Attachment Version new

Defines the the versioning mechanism for saved charts.

    • new — creates new version of the attachment.
    • replace — replaces all previous versions of the chart. To replace an existing attachment, the user must be authorized to remove attachments for the page specified.
    • keep — only saves a new attachment if an existing export of the same name does not exist. An existing attachment will not be changed or updated.
Attachment Comment none  Comment used for a saved chart attachment.
Thumbnail false
    •  true — the chart image attachment will be shown as a thumbnail.

Examples

Pie Chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Type pie

Fish Type

2011

Herring

9,500

Salmon

2,900

Tuna

1,500

Chart Title Fish Sold 2011
Show Legend true
Content Orientation vertical
   
   
   

 

Bar Chart

Parameters in Macro Browser Data Table in Macro Placeholder Rendered Chart
Type bar

Fish Type

2010

2011

Herring

9,500

8,300

Salmon

2,900

4,200

Tuna

1,500

1,500

Chart Title Fish Sold
Show Legend true

 
   
   
   
   

3D Bar Chart

Parameters in Macro Browser Data Table in Macro Placeholder Rendered Chart
Type bar

2009

2010

2011

Revenue

12.4

31.8

41.1

Expense

43.6

41.8

31.1

Show in 3D true
Opacity 50
Show Legend true
   
   
   
   

Time Series Chart

Parameters in Macro Browser Data Tables in Macro Placeholder Rendered Chart
Type Time Series

Month

Revenue

1/2011

31.8

2/2011

41.8

3/2011

51.3

4/2011

33.8

5/2011

27.6

6/2011

49.8

7/2011

51.8

8/2011

77.3

9/2011

73.8

10/2011

97.6

11/2011

101.2

12/2011

113.7

Month

Expenses

1/2011

41.1

2/2011

43.8

3/2011

45.3

4/2011

45.0

5/2011

44.6

6/2011

43.8

7/2011

51.8

8/2011

52.3

9/2011

53.8

10/2011

55.6

11/2011

61.2

12/2011

63.7

Date Format MM/yyyy
Time Period Month
Content Orientation vertical
Range Axis Lower Bound 0
Show Legend true
   
   
   
   
   

XY Line Chart

Parameters in Macro Browser Data Table in Macro Placeholder Rendered Chart
Type xyLine

12

14

23

Revenue

41.1

31.8

12.4

Expense

31.1

41.8

43.6

Show Legend true

 

XY Area Chart

Parameters in Macro Browser Data Table in Macro Placeholder Rendered Chart
Type xyArea
 

12

14

23

Revenue

41.1

31.8

12.4

Expense

31.1

41.8

43.6

Show Legend true
   
   
   
   
   

Area Charts

Example 1
Parameters in Macro Browser Data Table in Macro Placeholder Rendered Chart
Type area

Satisfaction

2009

2010

2011

Very satisfied

20

23

34

Satisfied

40

34

23

Dissatisfied

25

26

25

Very dissatisfied

15

17

18

Show Legend true
Width 300
Height 300
Opacity 50

 

Example 2
Parameters in Macro Browser   Data Table in Macro Placeholder Rendered Chart
Type area

Satisfaction

2009

2010

2011

Very satisfied

12

23

31

Satisfied

1

34

36

Dissatisfied

4

6

22

Very dissatisfied

2

7

12

Show Legend true
Width 300
Height 300
Stacked Values true

 

Gantt Chart

Parameters in Macro Browser Data Table in Macro Placeholder Rendered Chart
Type gantt
Plan Start End Status
Stage 1
6/25/2013
7/10/2013
30%
Stage 2
7/13/2013
11/28/2013
40%
Stage 3
12/1/2013
12/25/2013
 
Actual Start End Status
Stage 1
6/25/2013
7/26/2013 
100%
Stage 2
7/29/2013
12/01/2013
40%
Stage 3
12/10/2013
12/25/2013
 
Width 300
Height 200
Columns ,,1,2,3,4
Date format MM/dd/yyyy

 

Code examples

The following examples are provided for advanced users who want to edit the underlying markup for a Confluence page. 

Macro name: chart

Macro body: Accepts rich text, consisting of tables that hold the chart's data.

This macro recognises a large number of parameters, listed here by type for convenience.

  See all parameters...

Chart type parameters

These parameters determine the type of chart to display and how the chart looks.

Parameter Required Default Description
type No pie

The type of chart to display. XY charts have numerical x- and y-axes. The x values may optionally be time-based. See the timeSeries parameter.

Available values:

  • Standard charts - pie, bar, line, area
  • XY plotsxyArea, xyBar, xyLine, xyStep, xyStepArea, scatter, timeSeries
  • Other chartsgantt
orientation No vertical

The display orientation. Applies to area, bar and line charts.

Available values:

  • vertical –  y-axis is vertical
  • horizontal –  x-axis is vertical
3D No false

Show in three dimensions. Applies to area, bar and line charts.

stacked No false Stacked values. Applies to area and bar charts.
showShapes No true Applies to line charts. Shapes are shown at each data point.
opacity No
  • 75 percent for 3D charts
  • 50 percent for non-stacked area charts
  • 100 percent for all other charts
A percentage value between 0 (transparent) and 100 (opaque) that determines how opaque the foreground areas and bars are.

Chart display parameters

Parameter Required Default Description
width No 300 The width of the chart in pixels.
height No 300 The height of the chart in pixels.
dataDisplay No false

Determines whether to display the body of the macro, consisting of the data table. By default, the chart data table is not displayed.

Available values:

  • false – the data is not displayed.
  • true or after –  the data is displayed after the chart.
  • before – the data is displayed before the chart.
imageFormat No png

The image format to be used for the chart.

Available values:

  • png
  • jpg

Chart title and label parameters

Parameter Required Default Description
title No (None) The title of the chart.
subTitle No (None) A subtitle for the chart.
xLabel No (None) The label for the x-axis (domain).
yLabel No (None) The label for the y-axis (range).
legend No false Determines whether to show a legend (key) for the chart.

Chart data parameters

The data for the chart is taken from tables found in the macro body. The parameters below control how this data is interpreted. By default, numeric and date values are interpreted according to the Confluence global default language (locale) formats. If conversion fails, other languages defined in Confluence will be tried. You can specify additional conversion options using the parameters below.

Parameter Required Default Description
tables No All first level tables You can supply a comma-separated list of table IDs and/or table numbers (starting at 1) contained within the body of the macro that will be used as the data for the chart. If data tables are embedded in other tables, then table selection will be required. This occurs when more complex formatting is done (for example using section and column macros).
columns No All columns You can supply a comma-separated list of column labels and/or column titles and/or column numbers for tables used for chart data. This applies to all tables processed. Columns are enumerated starting at 1. Column label is the text for the column in the header row. Column title is the HTML title attribute for the column in the header row.
dataOrientation No horizontal

The content orientation. By default, the data tables will be interpreted as columns (horizontally) representing domain and x values.

Available values:

  • vertical  –  data table columns will be interpreted as series.
  • horizontal – data tables rows will be interpreted as series.
timeSeries No false

If 'true', the x values in an XY plot will be treated as time series data and so will be converted according date formats.

dateFormat No Confluence language defined date formats For time series data, the date format allows for additional customisation of the conversion of data to date values. If a dateFormat is specified, it will be the first format used to interpret date values. Specify a format that matches the time series data. See simple date format.
timePeriod No day

The time period for time series data. Defines the granularity of how the data is interpreted.

Available values: millisecond, second, minute, hour, day, week, month, quarter, year

language No (None)

Use in combination with the country parameter to form a locale. These additional number and date formats will be used for data conversion before the default languages.

Available values are the two-character ISO 639-1 alpha-2 codes.

country No (None) Use in combination with the language parameter to form a locale. Valid values are the two-character ISO 3166 codes.
forgive No true

Determines whether the macro will forgive (allow) some data formatting errors.

Available values:

  • true — the macro tries to convert numeric and date values that do not totally match any of the default or user-specified formats.
  • false — the macro enforces strict data formatting. If there are data format errors, the chart will not be produced.

Chart colour parameters

Colours are specified using hexadecimal notation or HTML colour names.

Parameter Required Default Description
bgColor No White Background colour of the chart.
borderColor No No border Colour of the border around the chart.
colors No   A comma-separated list of colours used to customise the colours of categories, sections, and series.

Chart axis parameters

Depending on the chart type, the range and domain axis may be customised. These values are automatically generated based on the data but can be overridden by specifying one or more more of these parameters.

Parameter Required Default Description
rangeAxisLowerBound No (None) Minimum value for the range axis.
rangeAxisUpperBound No (None) Maximum value for the range axis.
rangeAxisTickUnit No (None) Range axis units between axis tick marks.
rangeAxisLabelAngle No (None) Angle for the range axis label in degrees.
domainAxisLowerBound No (None) Only applies to XY plots. Domain axis lower bound. For a date axis, this value must be expressed in the date format specified by the dateFormat parameter.
domainAxisUpperBound No (None) Only applies to XY plots. Domain axis upper bound. For a date axis, this value must be expressed in the date format specified by the dateFormat parameter.
domainAxisTickUnit No (None) Only applies to XY plots. Domain axis units between axis tick marks. For a date axis, this value represents a count of the units specified in the timePeriod parameter. The timePeriod unit can be overridden by specifying a trailing character: y (years), M (months), d (days), h (hours), m (minutes), s (seconds), u (milliseconds).
domainAxisLabelAngle No (None) Only applies to XY plots. The angle for the domain axis label, in degrees. 
categoryLabelPosition No (None)

Placement of the axis label text for categories.

Available values:

  • up45 — 45 degrees going upward
  • up90 — 90 degrees going upward
  • down45 — 45 degrees going downward
  • down90 — 90 degrees going downward
dateTickMarkPosition No  start

Placement of the date tick mark.

Available values:

  • start — tick mark is at the start of the date period.
  • middle — tick mark is in the middle of the date period.
  • end — tick mark is at the end of the date period.

Pie chart Parameters

Parameter Required Default Description
pieSectionLabel No Show only the pie section key value Formatof pie section labels. The format uses a string with special replacement variables:
  • %0% is replaced by the pie section key.
  • %1% is replaced by the pie section numeric value.
  • %2% is replaced by the pie section percent value.

Example 1: To display something like 'Independent = 20':

%0% = %1%


Example 2: To display something like 'Independent (20%)':

%0% (%2%)
pieSectionExplode No No exploded sections A comma-separated list of pie keys that are to be shown exploded. Note: requires jFreeChart version 1.0.3 or higher.

Chart attachment parameters

These are advanced options that can be used for chart versioning, to enable automation and to improve performance. Use these options carefully! Normally, the chart image is regenerated each time the page is displayed. These options allow for the generated image to be saved as an attachment and have subsequent access to re-use the attachment. This can be useful especially when combined with the Cache plugin to improve performance. Depending on the options chosen, chart images can be versioned for historical purposes.

Parameter Required Default Description
attachment No (None)

The name and location where the chart image will be saved as an attachment. The user must be authorised to add attachments to the page specified.

Available syntax for this parameter:

  • ^attachmentName.png — the chart is saved as an attachment to the current page.
  • page name^attachmentName.png — the chart is saved as an attachment to the page name provided.
  • spacekey:page name^attachmentName.png — the chart is saved as an attachment to the page name provided in the space indicated.
attachmentVersion No new

Defines the the versioning mechanism for saved charts.

Available values:

  • new — creates new version of the attachment.
  • replace — replaces all previous versions of the chart. To replace an existing attachment, the user must be authorised to remove attachments for the page specified.
  • keep — only saves a new attachment if an existing export of the same name does not exist. An existing attachment will not be changed or updated.
attachmentComment No (None)  Comment used for a saved chart attachment.
thumbnail No false

 If true, the chart image attachment will be shown as a thumbnail (small, expandable) image.

Storage format example

Below is a simple example of a pie chart. See more examples in Storage Format Examples for Chart Macro.

Wiki markup example

Below is a simple example of a pie chart. See more examples in Wiki Markup Examples for Chart Macro.

Was this helpful?

Thanks for your feedback!

161 Archived comments

  1. User avatar

    Don Gamble

    Is there a way to control the color of the text labels?

    10 Jan 2009
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      No, but it would be a valid improvement request.

      10 Jan 2009
  2. User avatar

    Anonymous

    Hi,

    Is there a way to insert a numeric value in the body of a bar in the bar graph?

    Thanks

    20 Mar 2009
    1. User avatar

      Azwandi Aris [Atlassian]

      I am sorry that this feature is not available in the macro. Perhaps, this feature request might be the one you after?

      30 Mar 2009
  3. User avatar

    Anonymous

    Hi,

    Does this macro allow you to use an attachment (say a CSV file) as the data source?

    Thanks.

    16 Jul 2009
    1. User avatar

      Sashidaran Jayaraman [Atlassian]

      Hi,

      This is possible with the use of another plugin called CSV Macro.

      Hope this helps.

      Cheers
      JSashi

      16 Jul 2009
      1. User avatar

        Chris Kent

        Hi,

        What happened to the CSV Macro? The link above no longer works and I can't find it in the MarketPlace

        06 Feb 2014
        1. User avatar

          Bob Swift [Bob Swift Atlassian Add-ons]

          That was a really old link. CSV Macro is part of the Table Plugin (marketplace listing) and all the documentation is hosted on a new site. See Table Plugin for Confluence and CSV macro

          06 Feb 2014
          1. User avatar

            Chris Kent

            Awesome, thanks - I already own your Table plugin.

            I now have it up and running

            07 Feb 2014
  4. User avatar

    Anonymous

    Hi,

    Can you chart off a "dynamictable" macro?

    Steve.

    20 Jul 2009
    1. User avatar

      Zed Yap [Atlassian]

      Hi Steve,

      I am afraid that the feature requested is not available yet. Since, the dynamic macro is not part of this list:

      However, you might want to raise a feature request in JIRA:

      Hope that helps.
      Best rgds,
      Zed

      10 Aug 2009
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      You can make a chart off of almost any table that contains the right data.

      06 Feb 2014
  5. User avatar

    Anonymous

    Can I change the line style on a line graph?  I'd like to make some dashes as opposed to solid.

    09 Jul 2010
    1. User avatar

      Sashidaran Jayaraman [Atlassian]

      Hi,

      I am afraid that this is not currently possible. However, I have found a similar feature request Please add yourself as a watcher, vote for this feature and add your own comments to this feature request. For further details on how we include new features and improvements, you might want to read this page

      Cheers
      JSashi

      16 Aug 2010
  6. User avatar

    Anonymous

    Is there a way to specify the colors of the wedges of a pie chart?

    we use green = on time, blue = late and red = very late. The standard colors work OK; however, if there are none in a particular category, the colors move around.

    This one works:

    But this one does not:

    Thanks for your assistance,

    05 Oct 2010
    1. User avatar

      Anonymous

      Have you tried adding a wedge with a value of 0 as a place holder to keep the color assignments the same?

      21 Jan 2011
  7. User avatar

    Anonymous

    Is there any way to make multiple charts from one table. ie use columns 1,2 and 3 of a table for one graph and then 1,2 and 5 for some other graph? This is pretty much essential if the table's are generated by sql queries (and the SQL macro) because it becomes very inefficient to run 5 similar queries for 5 graphs.
    Thanks

    Iain

    11 Nov 2010
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      Put the sql query on a separate page surrounded by the cache macro. Include the sql page for each chart using the include macro. Use the columns parameter in the chart macro for the column selection.

      28 Feb 2011
      1. User avatar

        Kyle Conti

        Hi Bob - have there been any updates to facilitate multiple charts based upon a single table?  Or, is using the Cache macro still the only recommended solution?  Thanks for your help.

         

        26 Jul 2013
        1. User avatar

          Bob Swift [Bob Swift Atlassian Add-ons]

          No updates. Yes, the cache macro is the current solution. 

          27 Jul 2013
          1. User avatar

            Kyle Conti

            Hello again - as a related question from my post back in 2013...

            Is there a way to execute your Run macro to kick off a query that can display multiple charts?  Using your advice, we were able to display multiple charts for a single table.  Once we try to use your Run macro to execute it however, we don't seem to get the data.  Do you know if this is possible?  Any other tips to get this working?

            26 May 2015
            1. User avatar

              Bob Swift [Bob Swift Atlassian Add-ons]

              Yes. Just take it step by step. Each of the macros works with the right data, so you just need to build up each one so that it produces the expected data at each point. Use the chart macros dataDisplay parameter to make sure the chart macro is getting the data it needs. Use showSql parameter on the sql macros to make sure the substitutions for your SQL are as expected. Make sure each step produces what you expect. 

              27 May 2015
              1. User avatar

                Kyle Conti

                Thanks Bob, your macros work great.  We had everything set up just fine but I realized that in order to use an alias on the run, we needed to add the Run macro not only on the page with the charts, but on the page that had the single query. 

                For reference:

                Query page- Run macro (with alias info in "replace field list" paramenter) > Cache > SQL Query

                Chart page - Run macro (with alias info in "replace field list" paramenter) > Chart (1 to many) > Include page

                28 May 2015
  8. User avatar

    Anonymous

    Is it possible to add a vertical line to mark the median value on the x axis? For example, when charting a count of items by age, to indicate the median age. Thanks

    08 Dec 2010
  9. User avatar

    shlomi Podgorovich

    Hi,

    Is there a way to view the data labels ( like in excel) in a graph?

    I am not referring to the label name but to the value of the graph column.

    Thanks,

    05 Jan 2011
  10. User avatar

    Peter Alfvin

    I'd like to create a line chart where some of the lines don't extend all the way to the right, as used in an "actual vs. plan" chart.  However, if I leave the corresponding cells of the input table blank, they are treated as zeros, resulting in the line dropping to the x-axis at the point of the nulls and continuing on from there.

    Am I missing something?  Is this a feature request matter?  Has a request already been submitted?

    Thanks in advance for any info.

    Pete Alfvin

    P.S. I tried to include an image to show what I was looking for, but it wouldn't let me drag/drop a .jpg file from my desktop through Insert Image.

    05 Feb 2011
    1. User avatar

      Anonymous

      Same thing happened to me and I separated the data into two tables to work around the issue.

      Instead of:

      {chart}
      || Date || Planned || Actual ||
      | Jan 1 | 100 | 100 |
      | Jan 2 | 75 | 75 |
      | Jan 3 | 50 |    |
      | Jan 4 | 25 |    |
      | Jan 5 | 0  |    |
      {chart}

      Do this:

      {chart}
      || Date || Planned ||
      | Jan 1 | 100 |
      | Jan 2 | 75  |
      | Jan 3 | 50  |
      | Jan 4 | 25  |
      | Jan 5 | 0   |
      
      
      || Date || Actual ||
      | Jan 1 | 100 |
      | Jan 2 | 75  |
      {chart}

       

      Each day you add a value to actual, you create the row with the date and actual value.

      21 Dec 2011
      1. User avatar

        Furkan Paligu

        I try the same thing but my table is created by SQL queries and the head row, where you have "Date, Actual", is dynamic

        so it is like

        || Date || Pl || P2 ||
        | Jan 1 | 100 | 100 |
        | Jan 2 |    | 75 |
        | Jan 3 | 50 |    |
        | Jan 4 |    | 25 |
        | Jan 5 | 0  | 40 |

        and there can be a P3 or even P4 too
        so I really need it not to show the empty spaces as zero because can be misleading.
        Is there a way to not include those points in the chart?

        any info is appreciated

        24 Dec 2012
  11. User avatar

    Anonymous

    If I have an SQL plugin returning multiple tables, is there a way to have multiple charts based on that content? Splitting the SQL isn't an easy option since the data is built dynamically from relatively complex SQL.

    28 Feb 2011
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      Almost (sad). The tables parameter is meant for things like this. It is a way to specify explicitly what tables in the body are to be used for a chart. Macros like sql, table-plus, csv, excel all have an id parameter to explicitly put an id on a table. Unfortunately, the sql macro does not auto-increment the id for multiple result set tables. I have created SQL-109 to cover this case.

      28 Feb 2011
      1. User avatar

        Anonymous

        Thanks! So the multiple chart macros don't need to wrap around the SQL macro if the tables are numbered are somewhere in the page body? Have I got that right?

        28 Feb 2011
        1. User avatar

          Bob Swift [Bob Swift Atlassian Add-ons]

          I wasn't as complete as I needed to be. Any tables the chart macro needs to access MUST be in the body of the chart macro. In your case you probably need to use this technique as well once the issue gets fixed.

          01 Mar 2011
  12. User avatar

    Okan Aslaner

    Is there a way to drill down on charts? In other words, can I make the data points on a chart dynamic?

    22 Mar 2011
  13. User avatar

    Anonymous

    Is there a way to limit the width of the chart to a certain number of pixels irrespective of the data domain ?

    ^|____,____100

    and for same width in pixels

    |____,_____20

    22 Mar 2011
  14. User avatar

    Anonymous

    How to show DateTickMarks in "xyline" charts?

    How to use domainAxisTickUnit in "line" chart? This setting is neglected.

    How to change order of functions on "xyline" and "line" charts? Function drawn later overlaps function drawn earlier.

    Thanks

    01 Apr 2011
  15. User avatar

    Anonymous

    Is there any possible way to develop a time series chart but instead of a line, it has the area shaded in??

    29 Jun 2011
  16. User avatar

    Anonymous

    Is it possible to have a hyperlink in the chart? So when i press my line I get forwarded to another page?

    06 Jul 2011
    1. User avatar

      Anonymous

      Have you figured out how to get the drill through working?

      14 Jul 2011
      1. User avatar

        Bob Swift [Bob Swift Atlassian Add-ons]

        I have used imagemap macro in the past for things like this.

        14 Jul 2011
  17. User avatar

    Anonymous

    Can i have a chart with x-axis = day and y-axis = hour of the day?

    28 Jul 2011
  18. User avatar

    Anonymous

    Is the Gantt option of the chart macro still in beta? I am having trouble using it because the example code is not working for me

    Thanks!

    28 Jul 2011
  19. User avatar

    Barri Jansen

    Why isn't it possible to set the stacked=true parameter on the XY-plots charts.

    I've a timeseries data-range with 1 year of data, for each day a value. Plotting this in an Area chart the x-axis losses precision. With the xyArea chart I can set the domainAxisTickUnit=1M parameter. Which result in a nice x-axis showing each month!

    The data really makes more sense showing stacked. So I've to use the area chart, now I'm missing the x-axis :-(

    09 Aug 2011
    1. User avatar

      Frédéric Bonneau

      Hi Barri,

      Did you received any answer or find any solution to this point ? I've got the same problem.

      Thanks

      05 Aug 2015
  20. User avatar

    Anonymous

    Hi - is there a list of colours that can be used?

    Thanks and kind regards from Switzerland

    09 Aug 2011
    1. User avatar

      John Westlund

      Colours are specified by their Hexadecimal representation or HTML color: http://www.w3schools.com/tags/ref_colornames.asp

      07 May 2014
  21. User avatar

    Kenneth Houmark

    How do i turn a table (a SQL result) like this into a bar chart where y axis is Hours and the x-axis has a bar for each pair of User,Customer:

    User

    Hours

    Customer

    Paul

    30

    C1

    Paul

    2

    C2

    Lola

    3

    C3

    Using type = bar and dataOrientation=vertical does not work. Even tried with yLabel=Hours
    Been struggeling for hours! :D Would really help my company.

    25 Aug 2011
    1. User avatar

      Mike Frohme

      Hi Kenneth,

      This may not be the most helpful answer, but combining the User and Customer data into a single column with type bar" and orientation "vertical" accomplishes what you want, e.g.

      {chart:type=bar|dataOrientation=vertical|displayData=true}

      User+CustHours
      Paul (C1)30
      Paul (C2)2
      Lola (C3)3
      23 Sep 2011
      1. User avatar

        Anonymous

        Hi, I have a similar question.

        I am looking to use a BAR chart to display different arrival times of our input files for a given day.

        Hence my data looks something like this:

         

        File #Arrival Time
        File 1  2012-05-02 00:29:30.123
        File 2 2012-05-02 01:29:30:123 
        File 3 2012-05-01 23:59:20.123 

         My chart has:

        |type=bar|dataDisplay=true|width=1100|height=400|legend=true|dataOrientation=vertical|ylabel=Time

         But this isn't quite working out as I expect

        03 May 2012
  22. User avatar

    Anonymous

    I'd like to mark today's date in a gant chart with a vertical line, is that possible?

    31 Aug 2011
  23. User avatar

    Anonymous

    Dear All

    Is it possible to assing rangeAxisLowerBound to the minimum value automatically in dataset. I only see manual forcing of lower and uppper bound something like  |rangeAxisLowerBound=0I.

    Thank you very much.

     

    07 Sep 2011
  24. User avatar

    Anonymous

    I liked the old version of this page much better. In the new version it is not clear how the parameters are named.

    For example, the parameter borderColor is now called "Border Colour". This isn't very helpful (sad)

    23 Sep 2011
    1. User avatar

      Mike Frohme

      I agree completely - some names are directly related to what's in the description - e.g. dateFormat = "Date Format" but parameter rangeaxisupperbound is not intuitively obvious from "Range Maximum Value"  though the Domain axis appears to be better.

      I actually downloaded and scrounged the source to get to that ... grrr.

      23 Sep 2011
      1. User avatar

        Paul Watson [Atlassian]

        Hi Mike,

        Thanks for your comment. By way of explanation, the parameter descriptions on this page match those in the Macro Browser, which is what you use to configure macros in Confluence 4.0.

        I assume that you are using a version of Confluence earlier the 4.0. I think you will find the information you require if you refer to the version of the documentation that is relevant for your version of Confluence. Links are available at the top left of this page.

        I hope this helps,

        regards

        Paul

        05 Oct 2011
  25. User avatar

    Brooke Gravitt

    Wouldn't it be nice to include a code block with each example? You know, if only Confluence allowed you to do something like that...

     


    Pie Chart Example:

    Chart Code
    04 Oct 2011
  26. User avatar

    Anonymous

    Is there a reason why there is no selection in the parameters for the type of chart? Any time I make an edit to my bar chart, it reverts back to a pie chart and I have to start over again. I cannot seem to even open the wiki markup anymore to make the adjustments. 

    05 Oct 2011
  27. User avatar

    Anonymous

    Regarding the chart type bar parameters: Is there any way of displaying the numeric amount values over each specific bar?

    16 Oct 2011
  28. User avatar

    Anonymous

    The following parameters are documented wrong in the table above and they really should be:

     

    Range Axis Lower BoundnoneRange axis minimum value (ie y axis minimum)
    Range Axis Upper Bound
    noneRange axis maximum value (ie y axis maximum)
    Display Datafalse

    Sets whether to display the rendered body of the macro (usually the data tables). By default, the chart data table isn't rendered.

      • before — the data are displayed before the chart.
      • after — the data are displayed after the chart.
      • true — the data are displayed after the chart (same as the after parameter)
    11 Dec 2011
    1. User avatar

      Paul Watson [Atlassian]

      Thanks for your comment!

      You are describing an older version of Confluence, while this page describes the Chart Macro in Confluence 4.0.x.

      regards, Paul

      12 Dec 2011
  29. User avatar

    José Lecaros

    I'd like to display stacked values in a bar chart considering it's percentage in y axis. Let's say we have following table

    IngredientsSand1Sand2
    Bacon4516
    Green stuff58

    It should display 2 bars, one for Sand1 and one for Sand2, both bars should have same size and vary colors according to percentage. Say, Bacon-color in Sand1 should cover 90% of the bar, Green stuff color should use the 10%... same applies for Sand2's bar, 67% for bacon 33% for green stuff.

    Is this currently supported in chart macro?

     

    thanks in advance!

    08 Feb 2012
  30. User avatar

    Anonymous

    In confluence 4.1 how to create different chart types using Jira filters (jiraissues) and use them in WIki?

    09 Feb 2012
  31. User avatar

    Norbert Krupa

    Happy Valentines Day Bob!

    I was wondering if there was anyway to chart the following data without separating it into individual data sets:

    DateTimeValue
    2011-09-0110:00:005.5
    2011-09-0112:00:005.8
    2011-09-0210:00:003.4
    2011-09-0212:00:003.6
    2011-09-0310:00:004.1
    2011-09-0312:00:004.4

    So that it would have 3 lines (2011-09-01, 2011-09-02, 2011-09-03), Time on the X axis, and Value on the Y axis.

    Thank you in advance!

    14 Feb 2012
    1. User avatar

      Bob Swift

      I don't think so (sad).

      14 Feb 2012
  32. User avatar

    Anonymous

    Is there a way to just have the chart macro add the chart as an attachment to the page but not have it show up on the page?

    07 Mar 2012
  33. User avatar

    Xiang Zhang

    Hi,

    How to turn the time series chart X axis word direction? I've tested the examles, but the year is stacked. It's very mess.

    Thank you very much

    14 Mar 2012
    1. User avatar

      Bob Swift

      Probably you want: categoryLabelPosition=up90

      14 Mar 2012
      1. User avatar

        Xiang Zhang

        Hi Bob,

        Thanks in advance for your reply, but it seems was not working. I reply the screenshot to you in email, could you plesae check again?

        Regards

        15 Mar 2012
  34. User avatar

    Anonymous

    Excuse me, how can I align my chart to right side of the page?

    Thanks.

    16 Mar 2012
    1. User avatar

      Bob Swift

      Use the section/column macros or the float macro - {float: right}

      16 Mar 2012
  35. User avatar

    Anonymous

    Hi there,

    I'm using a timeSeries chart and I'm wondering if there's a way to specify missing values in some way and have a break in the timeSeries line to reflect that.

    For example, I might have data from a measurement instrument for March 11th, 12th, 14th, and  March 15th, but nothing for March 13th. Is there a way to have a line drawn for March 11th and 12th, a break, and then a line for March 14th and 15th?

     

    Thanks,

    Bill

     

    16 Apr 2012
  36. User avatar

    Jason Pepper

    How do you get a bar chart to display negative values ?

    I have a table of neg and pos values which I want to display above and below the zero line, but the chart resolutely displays them all as positive numbers..

    Thanks Jason

    25 May 2012
    1. User avatar

      Jason Pepper

      never mind - I worked it out, it was a scale thing.. normalise the candidate values and it all works

      25 May 2012
  37. User avatar

    Anonymous

    Is there a way to insert a numeric value in the body of a bar in the bar graph?

    26 Jun 2012
  38. User avatar

    Anonymous

    Hi,

    I have made a line graphs by taking the values from mysql database. I want to know that is it possible to display the values of all the points on this line, just like in excel sheet graphs?

     

    03 Aug 2012
  39. User avatar

    Richard Williams

    Would be very useful for scientific work if the bar graphs supported error bars.  ( Letter "I" shaped lines at top of bar showing uncertainty in metric. )

     

    09 Aug 2012
  40. User avatar

    Jesus Aguillon

    I want to be able to show both line data and bar data on the same chart.  Is it possible to do this using the chart macro?

    Thanks,

    18 Aug 2012
  41. User avatar

    Anonymous

    Is it possible to add a comment on the generated graph? like a arrow pointer explaining the spike or downward trend.

    31 Aug 2012
  42. User avatar

    Furkan Paligu

    Hi,

    I am using Bar Chart to represent some information that I take from the database. But it doesnt come out as it does on this page "Fish Sold" example where bars are side to side for each year. In my case the bars are shown above each other (so basicly there is only one chart for each year where fish types are represented with different colors)

    when I use the SQL statement without the chart, I get this

    Name2012-12-12012-12-5
    KO143
    KO233

    how can I get this in the form of the "Fish Sold" example ?

    thanks in advance

    20 Dec 2012
    1. User avatar

      Bob Swift

      Works exactly the same here. Make sure you don't have the stacked option chosen. 

      20 Dec 2012
  43. User avatar

    Furkan Paligu

    I did have the stacked option chosen.

    thanks

    20 Dec 2012
  44. User avatar

    Furkan Paligu

    hey,

    I try to create a line chart from the info I take from database, where I have projects (P1, P2, ...) and some read values of the projects at different times (Jan 1, Jan 2, ...)

    my problem is that, the blanks on the table below are represented as "0"s on the line chart which is very misleading because 0 means something totally different.

    I can not use multiple sql statements in the chart section because P1, and P2 are dynamic (they are the projects in the database)

    so it is like

    || Date || Pl || P2 ||
    | Jan 1 | 100 | 100 |
    | Jan 2 |    | 75 |
    | Jan 3 | 50 |    |
    | Jan 4 |    | 25 |
    | Jan 5 | 0  | 40 |

    and there can be a P3 or even P4 too
    so I really need it not to show the empty spaces as zero because can be misleading.
    Is there a way to not include those points in the chart?

    any info is appreciated

    24 Dec 2012
  45. User avatar

    Anonymous

    It would be helpful to be able to control the font size of the text labels and legend in the pie chart, is this possible?  I don't see any way to do this in any documentation, but thought I'd ask.

    28 Feb 2013
  46. User avatar

    Robert Down

    Is there a way to control granularity of the range tick units? For example, I'm attempting a chart that displays scientific data to the tenths decimal place, but cannot get my range values to display anything other than whole numbers.

     

    As it is now:

    90

    89

    88

     

    What I am trying to accomplish

    90.00

    89.75

    89.50

    89.25

    89.00

    17 Mar 2013
  47. User avatar

    Jason Pepper

    I need to create a "sales funnel" chart similar in design to the following image..

    does anyone know of a method or a plugin that would achieve this ?

     

    Thanks

    02 Apr 2013
  48. User avatar

    Anonymous

    I have an Macro Enabled Workbook (excel file) that I want to generate my graphs from. Currently it generates the graphs from the ".xls" version of the vile, but when I upload the ".xlsm" version of the same file the charts show up blank. Is this a limitation of Confluence?

    08 Apr 2013
  49. User avatar

    Anonymous

    Is it possible to create a chart based on the results of a JIRA filter? 

    12 Apr 2013
  50. User avatar

    Markus Lepper

    I've tried a lot but could not get the "Time Series Chart" example from above running if the two tables do NOT have the same first date column:

    How to get these two tables correctly being displayed?

    DateProdA
    12/20121
    03/20132
    04/20134
    DateProdB
    01/20136
    03/20135
    05/20132

     

    I always get a chart where the x-axis shows: 12/2012, 03/2013, 04/2013, 01/2013, 05/2013

    So first the chart macro collects all x-values from 1st table and then just add new x-values from 2nd table at the end instead if fitting in between at correct location.

     

    I tried different fomattings like Jan/2012, January 2012,... and played around with parameters, but...

    Any idea how to get an incremented time series displayed as chart?

    29 May 2013
  51. User avatar

    Xavier Arques

    The table-filter macro doesn't work inside the chart macro because the character " is replaced by " in the javascript

    Example:

    is replaced by :

    The error Uncaught SyntaxError: Unexpected token & is raised by Chrome.

    Any idea how to fix the problem ?

    11 Jun 2013
  52. User avatar

    Anonymous

    i want to make an XY recorder showing the plot between Pressure and Flow rate. How to write the macro code for this problem?

    pls help.

    n

    26 Jun 2013
  53. User avatar

    ChangJoon Lee

    Wow... gannt had been in beta from 2011?....

    It's time to get rid of Gantt option from chart plugin.

    02 Jul 2013
  54. User avatar

    Anonymous

    Hi,

    I using .xlsx files to create charts. Is there any way to get floating values?

    In my pages, 10.25 (ten dot twenty five) is read as 1025 (thousand twenty five)..

    Cheers (smile)

    22 Jul 2013
  55. User avatar

    Sivakumar Kailasam

    The width and height options don't work as expected, has anyone else faced this?

    01 Aug 2013
  56. User avatar

    Robert Romanczuk

    I am using the chart macro to render a stacked bar chart from a table.  For simplicity I will call the fields Label, Date and Number. The first column is for label, the remaining columns are dates and number is populated as appropriate for each row/column.

    Label08/05/201308/06/201308/07/2013
    RowA56 
    RowB 5 
    RowC2  

    I have the chart displaying stacked bars that show dates across the x axis and stack the number values within each date.

    My issues is that if I don't have any values for a certain date (indicated by a column with no dates, i.e 8/7/2013 above), the chart does not include this date where I would like it to.

    Is there a way to force the chart to include those columns on the x axis even when there is no data to display?

    05 Aug 2013
    1. User avatar

      Markus Lepper

      Robert, I've posted a similar questions some comments above...but unfortunately did not get any comment or tip...

      09 Aug 2013
  57. User avatar

    Patrick Cox

    So, I'm trying to create a Gantt chart, and would love to have this working, but I can't figure out what the heck is going on.  Selecting Gantt does not give me anything.  I got a stacked bar to sort of work, but can't get the time on the horizontal axis.  Does anyone know of any documentation that would help me get the gantt chart working or any suggestion on a different macro?  

    09 Sep 2013
  58. User avatar

    Anonymous

    I have the same issue..

     

    How to popluale the table in order to get the Gantt chart working

     

    /johan

    02 Oct 2013
  59. User avatar

    Anonymous

    Is it possible to display Legend vertically?

    04 Oct 2013
  60. User avatar

    Jason Halls

    Is there a way to pull data from tables nested in several pages to create a graph?

     

    I have three teams, all with their own line graph setup using the Chart plugin (so they each have their own table containing data) on three separate pages within the same space. On another page I would like to have a multi line chart with consolidated data from each of those tables.

    Is this possible?

    16 Oct 2013
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      Yes, you probably can depending on the data and chart type. The chart macro has a tables parameter which allows you to specify a list of table ids to be included in the table (and ignore other tables). Go to each page and find the table you want. Depending on how the table was produced you can either assign a specific table id (like if you used the sql or csv macros) ot use the table-plus macro to assign a specific id to the table. On the aggregating chart macro, use the include macro to include the other pages in the macro body.

      16 Oct 2013
      1. User avatar

        Jason Halls

        Hi Bob,

        Thanks for the fast reply. I have now added table ID's to the tables on all of my pages but I must be missing something as I cannot make it work;

        Some information on how I have set it up is as follows, and forgive me as I am relatively new to condluence.

        Table 1 created using macro Table Body (tbody) and given the ID - Table1
        Table 2 created using macro Table Body (tbody) and given the ID - Table2
        Table 3 created using macro Table Body (tbody) and given the ID - Table3

        All of the above tables are working in relation to their own charts

        On a separate page, I have created a new Chart but am having issues locating a Macro called include-macro So I am getting lost at this step.

        I have also tried to find the macro table-plus which I cannot locate in my list in the "select macro" section. I am using the hosted version and according to this page says it should be included.

        Any further assistance would be greatly appreciated.

        16 Oct 2013
        1. User avatar

          Anonymous

          Hi Bob.

          After some playing outside the pressures of work I have managed to make it work.

          Many Thanks

          16 Oct 2013
          1. User avatar

            Bob Swift [Bob Swift Atlassian Add-ons]

            Good. Sorry, I had a typo on the include (include page) macro. Corrected above.

            Regarding table-plus, it is included with OnDemand, however may not be enabled on your install - an admin needs to look for the Table Plugin in manage add-ons and enable it. 

            16 Oct 2013
  61. User avatar

    Tara McGarrigle

    Is it possible to displayData to the right or left of a chart rather than before or after?

    21 Oct 2013
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      No, not directly. That would be a nice improvement though. You can get the same result with a little extra work using layouts or section/column. If the data is inline, you could put it on a separate page and include it twice, once in the chart macro and once in the other column.

      21 Oct 2013
      1. User avatar

        Tara McGarrigle

        Thank you for the quick reply.  I'm using the sql plugin to pull in the data and can include the data twice to build the chart and then list as a table.  However the autoTotal does not appear work in the sql macro when it follows the chart macro and this is needed for what I am trying to display.  Any idea how to get the autoTotal to work?

         

        21 Oct 2013
        1. User avatar

          Bob Swift [Bob Swift Atlassian Add-ons]

          Hmmm, that is quite an old problem. Are you current with the SQL plugin? If you are and it is still occurring, open an issue with more specific details as I cannot reproduce that. It has to do with missing javascript. Even if you have an older version, you can work around that by placing an empty csv macro at the top of the page.

          21 Oct 2013
          1. User avatar

            Tara McGarrigle

            I am using an older version and the empty csv macro did the trick!

            Thanks!

            21 Oct 2013
  62. User avatar

    Anonymous

    Category Label Position doesn't seem to be working.

    I tried all options, but still the date labels are overlapped and messy.

    Anyone has any idea?

    Thanks alot!

     

     


    28 Nov 2013
  63. User avatar

    Anonymous

    Category Label Position doesn't seem to be working.

    I tried all options, but still the date labels are overlapped and messy.

    Anyone has any idea?

    Thanks alot!

     

     


    28 Nov 2013
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      It does work in general (smile). Try again or show us your example that doesn't work.

      17 Dec 2013
  64. User avatar

    Charlie

    is there a possibility to create more than one chat per datasource? At the moment I need to copy the datasource to create two or three different charts and filling our the datasources three times is a time killer

    17 Dec 2013
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      I assume you mean query. Put your query on separate page and then use the include page macro to include it into each of the chart macros where you need the data. Consider using the cache macro on the query page to save resources.

      17 Dec 2013
  65. User avatar

    Abhijit Sarkar

    Hi,

     All that i want to generate a line chart using the below two tables.

    But for 2nd table data connected line not shown properly.

     Whereas if I prepare XYLine chart or Timestamp Chart for the same then the data shows correctly.

     Is there a way to get an ideal line chart for below data?

    Issue_Creation_DateIssue_Reported (Cumulative Sum)
    2013-12-0921
    2013-12-1022
    2013-12-1126
    2013-12-1227
    2013-12-1336
    2013-12-1637
    2013-12-1739
    2013-12-1840
    2013-12-2042
    2013-12-2352
    2013-12-2455
    2014-01-2272
    2014-01-2385

     

     

    Issue_Resolution_DateIssue_Resolved (Cumulative Sum)
    2013-12-105
    2013-12-1120
    2013-12-1223
    2013-12-1326
    2013-12-1630
    2013-12-1731
    2013-12-2035
    2013-12-2439
    2014-01-2243
    28 Jan 2014
    1. User avatar

      Navdeep Jandu

      Are you using timeSeries for the first table?

      Just a guess but your problem maybe the type of chart your using (most likely timeseries) cannot handle non-consecutive dates, where your parameters are days apart.. eg in your second table there is a gap between your dates. Therefor you may have to use another type of chart.

       

      03 Feb 2014
  66. User avatar

    Navdeep Jandu

    Hi Bob,

    I am using a bar chart, where some of the bars I want to be different color based on another column. for example if the severity = 2 then have the bar color red, if severity = 1 then bar color amber. So far all the bars are just one color. If there any way to do this? this would be a great feature if it has not been used already 

    My table I want to extract from looks like this but with more data.

    DateDescriptionSeverity
    20/1492%2
    21/1414%0
    22/1474%1
    23/1493%2
    24/1425%0

     

     

     

    28 Jan 2014
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      Not that I know of.

      07 Mar 2014
  67. User avatar

    Chris Kent

    Hi, is it possible in a timeseries graph to add vertical date markers on the graph for important (configurable) dates, such as today's date or release date? Similar to the Version Report in the Agile Reporting charts.

    17 Feb 2014
  68. User avatar

    Andreas Grossnick

    Hi,

    I'm using the gantt chart to display activities happening within one day. Whilst the macro displays exactly down to hours and minutes, the scale doesn't adjust to show more detail e.g. hours or quarters of a day or so. is this a limitation of the macro?

    Thanks for your help

    07 Mar 2014
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      Try setting the domainAxisTickUnit using:

      yyear
      Mmonth
      dday
      hhour
      mminute
      ssecond
      umillisecond
      07 Mar 2014
      1. User avatar

        Andreas Grossnick

        Thanks Bob for the quick response. I've tried to modify the chart using various combinations of this, but the chart seems to ignore whatever I enter into the domainAxisTickUnit parameter. Are you able to provide an example?

        07 Mar 2014
        1. User avatar

          Bob Swift [Bob Swift Atlassian Add-ons]

          Sorry, no, it was just a guess on my part. If that doesn't do it, then I would suspect it just not supported.

          07 Mar 2014
  69. User avatar

    Anja Fust

    Hi,

    is it possible to configure the bar chart that was, that the axis will only show integer (not decimal) values ? To prevent this I´m using currently the setting "Range Axis Tick Unit" , but this way is quite inflexible in case of highly different variance for totals in the chart, so would be much easier just to set a setting like "axis values" = "integer" 

    Thanks Anja

    14 Mar 2014
    1. User avatar

      Andreas Grossnick

      I was looking for a feature like this as well. Thanks, Andreas

      16 Mar 2014
  70. User avatar

    Tom Dickson

    It would be nice to be able to put the table to the left or right of the chart instead of just above or below.

    28 May 2014
  71. User avatar

    Urs Kemmann

    The Gantt chart isn't working and its impossible to figure out how to get it to work with these instructions. It would be great to have it.

    05 Jun 2014
    1. User avatar

      Rachel Robins [Atlassian Tech Writer]

      Hi Urs, the Gantt chart is very tricky to figure out.  First of all, are you able to get it working using the exact example above (I've just tested this example and it works correctly) this will help troubleshoot whether its a problem with the macro, or the data.  Another important thing I found when setting it up is that the column parameter must be exactly as they are presented in the example, including the two leading commas:

      ,,1,2,3,4
      05 Jun 2014
  72. User avatar

    Paul LaBarbera

    The Marketplace listing for the Chart macro says that it's only compatible <5.4.4. Is this compatible with Confluence 5.5+?

    05 Aug 2014
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      It is bundled with the Confluence release, so is always compatible. The marketplace entry is often not accurate.

      05 Aug 2014
      1. User avatar

        Paul LaBarbera

        Duh. I looked right over it.

         

        Thanks Bob!

        05 Aug 2014
      1. User avatar

        Rachel Robins [Atlassian Tech Writer]

        Hi Paul, sorry for the confusion, I've raised a request for the marketplace entry to be corrected. 

        Thanks Bob (smile)  

        06 Aug 2014
  73. User avatar

    Christine Duke

    Is there a way to change the colors of the actual bars in the gantt chart from red and green to something else?

    11 Aug 2014
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      You should be able to use the colours parameter.

      11 Aug 2014
      1. User avatar

        Christine Duke

        The colours parameter only seems to change the color in the box that the green/red bar is in but not the actual bar colors. Is there something I am missing there?

        12 Aug 2014
        1. User avatar

          Bob Swift [Bob Swift Atlassian Add-ons]

          I don't have any further suggestions (sad)

          12 Aug 2014
  74. User avatar

    Christophe Bonvin

    Is there a way to combine a bar chart and a line chart. I would like to have 2 series charted as bar and on serie charted as line.

    Thank you

    14 Nov 2014
    1. User avatar

      Rachel Robins [Atlassian Tech Writer]

      Hi Christophe, sorry I'm not aware of a way to do that with the chart macro. 

      21 Nov 2014
  75. User avatar

    Sandra Axelsdóttir [Tempo]

    Hi,

    We just updated our Confluence to 5.6.4 and this macro stopped working and is not visible at all. Any tips?

    20 Nov 2014
    1. User avatar

      Rachel Robins [Atlassian Tech Writer]

      Hi Sandra, sounds like you might have found a bug.  Could you raise an issue with some more details so the team can investigate?

      21 Nov 2014
      1. User avatar

        Sandra Axelsdóttir [Tempo]

        Yes, I can do that. I raised an Issue in your support system (CSP-135527), but the link you have in your comment is dead (oops, you've found a dead link).

        21 Nov 2014
        1. User avatar

          Rachel Robins [Atlassian Tech Writer]

          Sorry about that, have fixed the link. As you've already raised a support ticket, I'm sure the support team will raise the bug if necessary. 

          23 Nov 2014
  76. User avatar

    Karie Kelly

    Can you clarify with some examples by what you mean regarding the columns parameter: Comma separated list of column labels and/or column titles and/or column numbers for tables used for chart data. This applies to all tables processed. Columns are enumerated starting at 1. Column label is the text for the column in the header row. Column title is the (html) title attribute for the column in the header row.  

    We tried inputting the column names that we wanted to include and had them exactly as the table headers, but on preview, we received the error: '' could not be converted to date.  Once we removed the titles, then it worked fine. But, we weren't certain if you were stating the text, IDs, or html was to be input into this field. 

    26 Nov 2014
  77. User avatar

    satish

    Can someone help with how to use Table ID ? I want to create a gantt chart with Planned (start. End date) and Actual (start,End Date). Which are columns in same table. I donot want to use two tables. i,e one or Planned and one for actual. But rather use One table that has 4 columns where each column is a date. Please help

     

    30 Dec 2014
    1. User avatar

      Giles Brunning [Atlassian Technical Writer]

      Hi Satish,

      Sorry, I've only had success with the Gantt example on this page, which does show planned and actual in the one chart (even if the data is in 2 tables).

      If that's not what you're after, you could try asking over at answers.

      30 Dec 2014
  78. User avatar

    barbarat

    How do we get the chart to show 2 sets of data as seen in the "Time" example above (Revenue vs. Expenses)? I have 2 tables created in the Chart macro and it doesn't show the 2nd value set.

    22 Jan 2015
    1. User avatar

      Giles Brunning [Atlassian Technical Writer]

      Hi,

      Sorry, I can't replicate the issue you're having. I've copied the example provided on this page to a page in my local instance, and it seems to be working fine (the chart displays the 2 sets of data as expected).

      26 Jan 2015
  79. User avatar

    Jens Kasperek

    How can I add data from database for chart macro and is there a way that only confluence administrators can use such data?

    The idea behind this is to offer usage data of our Confluence instance to our customers.

    30 Jan 2015
  80. User avatar

    Bob Swift [Bob Swift Atlassian Add-ons]

    You can use SQL for Confluence to bring SQL data into Confluence including use by a chart macro. Use of the sql macros can be secured using Macro Security for ConfluenceHow to use Confluence for Business Intelligence and Reporting has related information.

    30 Jan 2015
  81. User avatar

    eric glismann

    Is there a way to label each, data point in a line chart? 

    below is my chart

     

    26 Mar 2015
    1. User avatar

      Giles Brunning [Atlassian Technical Writer]

      Hi Eric,

      Unfortunately, I don't think it's possible. Feel free to make a suggestion so we can track the demand.

      07 Apr 2015
  82. User avatar

    Matthew Carr

    Is there a way (or workaround) to display the rendered data table to the right (or the left) of a pie chart?  Sounds like a small thing, but it would make the page look tidier and improve PDF exports...

    28 Apr 2015
    1. User avatar

      Bob Swift [Bob Swift Atlassian Add-ons]

      No. That would be nice to have though. The workaround is to put the table on its own page and include it twice, once for the chart and once for where ever else you want it.

      28 Apr 2015
  83. User avatar

    Kent cross

    I'm trying to duplicate the chart that appears above in Screenshot 1 & 2, but I'm having problems getting my dates to render across the X Axis the same way as the example. 

    How did you get the dates to render vertically?

    My chart values equals yours, and here are my macro settings. Anything not listed is blank:

    Type: timeSeries

    Display Orientation: horizontal

    Horizontal-axis Label: # issues

    Vertical-axis Label: Date

    Show Legend? Checked

    Columns: Weeks, Issues Burndown

    Content Orientation: vertical

    Time Series? Checked

    Date Format: dd/MM/yyyy

    Time Period: Week

    Forgive: Checked

    Domain Axis Tick Unit: 1 gives me lots of overlapping dates.

     

     

     

     

    25 May 2015
    1. User avatar

      Kent cross

      I solved my own problem. There is a Chart MAcro attribute named "domainaxisrotateticklabel" that cannot be selected through the Macro GUI. I had to manually add it through the Source Editor.

      28 May 2015
  84. User avatar

    aschwartz

    Hi,

    I have a problem with the timeSeries chart: I try to use it with two tables for the input rather than one. The error message I see instead of the rendered chart is:

    You are attempting to add an observation for the time period Week 1, 2005 but the series already contains an observation for that time period. Duplicates are not permitted. Try using the addOrUpdate() method.

     

    My two tables have exactly the same date entries. I tested two option with the same result:

    • inlined wiki tables
    • inlined CSV tables. 

    Any ideas?

    Cheers

    Alex

    10 Jun 2015
  85. User avatar

    John Goodson

    Is it possible to use the chart macro with an excerpt macro?

    I have a Gantt chart macro working, but instead of having to update the content directly on the page, I wanted to pull that content from other pages. I am using the Content by Label macro with the excerpt function. I think that the elements around the except are causing the problem as I can get it to work if I copy & paste the tables in manually.

    The error I am seeing is:

    Error rendering macro 'chart' : org.dom4j.DocumentException: Error on line 6 of document : The entity "mdash" was referenced, but not declared. Nested exception: The entity "mdash" was referenced, but not declared.

    Any ideas?

    05 Aug 2015
    1. User avatar

      Giles Brunning [Atlassian Technical Writer]

      Hi John,

      The short answer to the first question is yes, but it depends a lot on what you mean by 'use with.' You can have the chart in an excerpt macro on another page, and include that excerpt on another page using the excerpt include.

      Not sure how the content by label fits into the scenario, though.

      Regarding the error, if it's still an issue, you'd be best talking to support about that one.

      05 Aug 2015
      1. User avatar

        John Goodson

        Hi Giles,

         

        I may be trying to be extra fancy. What I really want to do is roll up a Gantt from 4 sub teams on a top level page. So each sub team page has a table that if included directly in the chart macro would create a reasonable chart. I have the exact same table on each of the 4 pages and that table is inside the excerpt macro. Each of these four pages has a specific label I am using.

        Then on the top level page I can create a content by label macro and if I select the include excerpt option it pulls the tables (plus a bit of other stuff) onto my main page. However, if I try to place that macro inside the chart macro, I get this error.

        05 Aug 2015
    1. User avatar

      Xavier Arques

      Hi John,

      I am able to display a Chart based on data included in a Excerpt macro. I've got a error similar to yours but only during the preview on the Chart Macro.

      If you save the page, the Gantt chart should work. Can you confirm ?

      05 Aug 2015
      1. User avatar

        John Goodson

        HI Xavier,

        I get the error both on preview and save. Are you using just excerpt or something that pulls in multiple pages with an include excerpt option?

        05 Aug 2015
    1. User avatar

      John Goodson

      After working with this for a bit, it works fine using the excerpt-include macro, i just have to add an excerpt include for each page I want to include in the chart. I was trying to use the Content by Label with an excerpt option, but no matter what I do, I can't remove the "title" in front of the excerpt and that is causing the problem. 

      I got it to work as a workaround

      05 Aug 2015
Powered by Confluence and Scroll Viewport