Exploratory
  • Introduction
  • Product Features
    • Summary View
    • Table View
    • Row Filter
    • Column Filter
    • Dashboard
    • Dashboard (日本語)
    • Note
    • Note (日本語)
    • Steps (Right-hand side)
    • Branch
    • Parameter
    • Parameter (日本語)
    • Export
    • Share
      • Share Type
      • Chart / Analytics
      • Data
      • Report (Note / Dashboard)
      • Notification
      • Version History
      • Restore Older Version
      • CSV API
    • Share (日本語)
      • 共有のタイプ
      • チャート / アナリティクス
      • データ
      • レポート (ノート / ダッシュボード)
      • 通知
      • バージョンの履歴
      • 古いバージョンの復元
      • CSV API
    • Schedule
      • Manage Schedules
      • Notification
      • Scheduling History
    • Schedule (日本語)
      • スケジュールの設定
      • 通知
      • スケジュールの履歴
    • Team
      • Manage Teams
    • Team (日本語)
      • チームの設定
    • Project
      • Import
      • Export
      • Search
  • Data Import
    • File Data
      • CSV / Delimited File
      • Amazon S3
      • Google Drive
      • Google Cloud Storage
      • Excel
      • JSON
      • Log File
      • Microsoft Azure
      • Stats - SAS / SPSS / STATA
      • RData / RDS
      • Parquet File
      • EDF - Exploratory
    • Database Data
      • SQL Troubleshooting
      • Create Connection
      • Amazon Athena
      • Amazon Aurora
      • Amazon Redshift
      • Amazon Redshift (日本語)
      • Google BigQuery
      • HP Vertica
      • MariaDB / MySQL DB
      • MariaDB / MySQL DB (日本語)
      • Microsoft Access
      • MongoDB
      • ODBC
      • Oracle
      • PostgreSQL
      • PostgreSQL (日本語)
      • Presto
      • Snowflake
      • SQLServer (DSN)
      • SQLServer
      • Teradata
      • Treasure Data
    • Cloud Apps Data
      • Create Connection
      • FRED - Federal Reserve of Economic Data
      • Github Issues
      • Google Analytics
      • Google Analytics (日本語)
      • Google Spreadsheet
      • Google Cloud Storage
      • Salesforce
      • Twitter Search
      • Stripe
      • Weather Data
      • Stock Price Data
    • Write R Script as Data
      • Currency Exchange Rate
    • Write R Script as Data (日本語)
    • Web Page Scraping
    • Text Input Data
    • Data Source Extension
      • Quandl
      • Holiday
      • RSS Data
    • Create Custom Data Source
  • Data Wrangling
    • Command Line mode for faster and more flexible data interaction in Exploratory
    • Select / Remove Columns
    • Reorder Columns
    • Create New Calculation
    • Create New Calculation for Multiple Columns
    • Summarize (Aggregate)
    • Group
    • Filter
    • Rename
    • Arrange (Sort)
    • Top / Bottom N
    • Join
    • Merge
    • Gather
    • Spread
    • Pivot
    • Expand
    • Complete
    • Separate
    • Unite
    • Bind Rows
    • Bind Columns
    • Keep Only Unique Rows
    • Keep Only Duplicated Rows
    • Slice
    • Drop NA
    • Sample
    • Impute NA
    • Fill
    • Create Buckets
    • Assign New Values to Existing Values - Recode
    • Assign New Values by Setting Conditions - Case When
    • Work with Categories
    • Data Type Conversion
    • Row as header
    • Ungroup
    • Unnest
    • Separate List Items into Columns (Unnest Wider)
    • Separate List Items into Rows (Unnest Longer)
    • Separate Address (Japan)
    • Hoist
    • Remove Empty Rows
    • Remove Empty Columns
    • Clean Column Names
    • Window Calculation
    • Window Calculation (日本語)
    • Add Row
    • Text Wrangling
    • Regular Expression Cheat Sheet
    • Regular Expression Cheat Sheet (日本語)
  • Visualization
    • Types
      • Pivot
      • Summarize Table
      • Table
      • Bar
      • Line
      • Area
      • Pie/Ring
      • Radar
      • Histogram
      • Density Plot
      • Scatter (No Aggregation)
      • Scatter (With Aggregation)
      • Boxplot
      • Violin
      • Error Bar
      • Error Bar (Summarized Data)
      • Map - Standard
      • Map - Extension
      • Map - Long/Lat
      • Map - Heatmap
      • Heatmap
      • Contour
      • Number
      • Word Cloud
      • Word Cloud (日本語)
    • Features
      • Trend Line
      • Reference Line
      • Repeat By
      • Window Calculation
      • Date/Time Aggregation
      • Show Range
      • Highlight
      • Change Marker
      • Multiple Y-Axis Columns
      • Layout Configuration
      • Column Configuration
      • Column Configuration Dialog
      • Color and Group Setting
      • Color and Group Setting (日本語)
      • Color Setting
      • User Color Palette Setting
      • Pin
      • Save as PNG/SVG
      • Save as Exploratory Data File
      • Share/Schedule
      • URL Link
      • Category (Binning)
      • Highlight
      • Limit Values
      • 'Others' Group
      • Edit Display Name
      • Missing Value Handling
      • Rename Column Names
      • Axis Setting
      • Axis Formatting
      • Show Detail
      • Fit to Screen (Table)
      • Number of Unique Values Check
      • Number of Unique Values Check (日本語)
  • Analytics
    • Correlation
    • Distance
    • K-Means Clustering
    • Principal Component Analysis
    • Factor Analysis
    • Correspondence Analysis
    • Linear Regression Analysis
    • Logistic Regression Analysis
    • Generalized Linear Models
    • Survival Curve
    • Cox Regression
    • Random Survival Forest
    • Decision Tree
    • Random Forest
    • XGBoost
    • Time Series Forecasting (Prophet)
    • Time Series Forecasting (ARIMA)
    • Time Series Clustering
    • Anomaly Detection
    • Word Count
    • Text Clustering with Topic Model (LDA)
    • Market Basket Analysis
    • T Test
    • T Test (Aggregated Data)
    • ANOVA
    • Wilcoxon Test
    • Kruskal-Wallis Test
    • Chi-Square Test
    • A/B Test
    • Normality Test
    • Prediction
    • Dictionaries for Text Analysis
  • Statistics
    • Correlation
    • Distance
    • Cosine Similarity
    • SVD
    • Multi Dimensional Scaling
    • T-test
    • F-test
    • Chi-square test
    • A/B Test (Bayesian)
  • Machine Learning
    • Linear Regression
    • Logistic Regression
    • GLM
    • Multinomial Logistic Regression
    • K-means Clustering
    • Random Forest
    • XGBoost
    • Forecasting
    • Time Series Clustering
    • Anomaly Detection
    • Survival Curve
    • Survival Model (Cox Regression)
    • Market Basket
    • Causal Impact
    • Evaluate Prediction - Regression
    • Evaluate Prediction - Binary
    • Calculate ROC
    • Evaluate Prediction - Multiclass
    • Prediction
    • Prediction - Binary Classification
    • Prediction - Survival Model
    • Simulate Survival Curve
    • Extract Summary of Fit
    • Extract Parameter Estimates
    • Run ANOVA Test
    • Fix Imbalanced Data (SMOTE)
  • Text Analysis
    • Tokenize Text
    • Create N-gram Tokens
    • Calculate tf-idf
    • Count Text Pairs
  • Extend with R
    • R Package Install
    • Custom R Script
    • Custom Model Function
  • Setup
    • Disable McAfee virus scan
    • Change Repository Location
    • Change Repository Location (日本語)
    • Holidays Data for Forecast
    • Possible Reasons for Install Error
    • Upgrade Microsoft .NET Framework
  • Diagnostics
    • Log file for debugging
    • Log file for debugging (日本語)
    • Startup Log file for debugging
    • Startup Log file for debugging (日本語)
    • Check version of Exploratory Desktop
    • How to Recover the History Data
  • Keyboard shortcuts
Powered by GitBook
On this page
  • Generic Charts
  • Tick Label Auto Scaling
  • Maps
  • Pivot Table / Summarize Table
  • Table

Was this helpful?

  1. Visualization
  2. Features

Layout Configuration

PreviousMultiple Y-Axis ColumnsNextColumn Configuration

Last updated 2 years ago

Was this helpful?

You can configure the layout and format of the chart such as margins, font size or title on the Layout property dialog. You can access to the dialog by clicking "Layout" button at the top right corner of the chart.

The dialog content changes depending on the chart type. See following for more detail.

Generic Charts

Generic Charts includes following chart types.

  • Bar

  • Line

  • Area

  • Pie / Ring

  • Histogram

  • Density Plot

  • Scatter (No Aggregation)

  • Scatter (With Aggregation)

  • Boxplot

  • Violin

  • Error Bar

  • Heatmap

  • Contour

Following layout properties are available for those type of charts.

  • Plot Area

    • Number of Decimal Digits - Number of decimal digits to round.

    • Show Values on Plot

      • (None)

      • Above

      • Middle

      • Below

    • Text Angle for Values - You can set an angle to the value text on plot.

    • Show Values if Greater than This Value - You can show values on plot only for the values that are greater than this setting.

    • Font Size

    • Font Size Auto Adjust - If it is checked, the value text on the plot automatically adjusts the size to avoid overlapping each other.

    • Add Space Between Bars (Bar chart only) - You can add a space between grouped bars.

  • Legend

    • Title Text

    • Title Font Size

    • Position

      • Right - Default

      • Left

      • Top

      • Bottom

      • None - Hide legend itself

    • Font Size - Font size for the legend text in pixel

  • Title

    • Text - Title text

    • Font Size (numbers in pixel)

    • Alignment

  • X Axis Title

    • Title Text

    • Title Font Size (numbers in pixel)

  • X Axis

    • Show Label

    • Tick Label Font Size (numbers in pixel)

    • Show Grid Lines

      • Default - Depending on chart type

      • On - Show explicitly

      • Off - Hide explicitly

    • Show Zero Lines

      • Default - Depending on chart type

      • On - Show explicitly

      • Off - Hide explicitly

  • Y Axis Title

    • Title Text

    • Title Font Size (numbers in pixel)

  • Y Axis

    • Show Label

    • Tick Label Font Size - Font size in pixel

    • Show Grid Lines

      • Default - Depending on chart type

      • On - Show explicitly

      • Off - Hide explicitly

    • Show Zero Lines

      • Default - Depending on chart type

      • On - Show explicitly

      • Off - Hide explicitly

  • Z Axis Title

    • Title Text

    • Title Font Size (numbers in pixel)

  • Z Axis (Only available for Scatter (No Aggregation) charts with Z-Axis assigned)

    • Show Label

    • Tick Label Font Size (numbers in pixel)

    • Show Grid Lines

      • Default - Depending on chart type

      • On - Show explicitly

      • Off - Hide explicitly

    • Show Zero Lines

      • Default - Depending on chart type

      • On - Show explicitly

      • Off - Hide explicitly

  • Margin

    • Top (numbers in pixel)

    • Left (numbers in pixel)

    • Bottom (numbers in pixel)

    • Right (numbers in pixel)

Tick Label Auto Scaling

If you assign a numeric, Date or POSIXct column to X-Axis and you want to show the labels for all the data points on X-Axis, you can uncheck the "Tick Label Auto Scaling" option. This option is currently avaiable in Bar, Line and Area charts.

Maps

Maps includes following chart types.

  • Map - Long/Lat

  • Map - Heatmap

  • Map - GeoJSON

Following layout properties are available for those type of charts.

  • Plot Area

    • Number of Decimal Digits - Number of decimal digits to round.

  • Map

    • Type - Map type

      • Light

      • Dark

      • Streets

Pivot Table / Summarize Table

The following layout properties are available for Pivot Table and Summarize Table.

  • General

    • Font Size

    • Display Text for NA - You can customize the text for NA values. Default is blank.

    • Show All Categorical Values - If you assign a factor column to Row, Column or Group By, show all the categories (factor levels) even there is no data for categories.

    • Show Popup on Hover - Show a Popup on hovering a value text.

    • Limit # of Rows to Show - Enable or disable limiting the number of rows to show. Default is "Yes".

    • Max # of Rows To Show - Max number of rows to show. It is effective only if you set the "Limit # of Rows to Show" option above. If you don't specify the value, it will be calculated automatically to show up to 10,000 table cells on the screen.

  • Number Formatting

    • Number of Decimal Digits - Number of decimal digits to round.

  • Title

    • Text

    • Font Size

  • Value Columns

    • Show Function Names

    • Hide Data Cells - It shows only column headers if you enable it.

    • Sort within Group - It changes the sorting behavior when you click the column header of the table. If it is checked, the sort is done for each Row group. If unchecked, the sort is done beyond the group.

Table

  • Table

    • Title - Title text

  • Plot Area

    • Number of Decimal Digits - Number of decimal digits to round.

Sort within Group: On - The sort is done for each Row group.

Sort within Group: On - The sort is done beyond Row groups.