umya_spreadsheet/structs/

chart.rs

use crate::drawing::charts::NumericValue;
use crate::drawing::charts::RichText;
use crate::office2010::drawing::charts::Style;
use crate::structs::drawing::charts::Area3DChart;
use crate::structs::drawing::charts::AreaChart;
use crate::structs::drawing::charts::AreaChartSeries;
use crate::structs::drawing::charts::AreaChartSeriesList;
use crate::structs::drawing::charts::AxisId;
use crate::structs::drawing::charts::AxisPositionValues;
use crate::structs::drawing::charts::Bar3DChart;
use crate::structs::drawing::charts::BarChart;
use crate::structs::drawing::charts::BarDirectionValues;
use crate::structs::drawing::charts::Bubble3D;
use crate::structs::drawing::charts::BubbleChart;
use crate::structs::drawing::charts::BubbleSize;
use crate::structs::drawing::charts::CategoryAxis;
use crate::structs::drawing::charts::CategoryAxisData;
use crate::structs::drawing::charts::ChartSpace;
use crate::structs::drawing::charts::ChartText;
use crate::structs::drawing::charts::CrossBetweenValues;
use crate::structs::drawing::charts::DisplayBlanksAsValues;
use crate::structs::drawing::charts::DoughnutChart;
use crate::structs::drawing::charts::GroupingValues;
use crate::structs::drawing::charts::InvertIfNegative;
use crate::structs::drawing::charts::Layout;
use crate::structs::drawing::charts::LegendPositionValues;
use crate::structs::drawing::charts::Line3DChart;
use crate::structs::drawing::charts::LineChart;
use crate::structs::drawing::charts::MajorGridlines;
use crate::structs::drawing::charts::OfPieChart;
use crate::structs::drawing::charts::OfPieValues;
use crate::structs::drawing::charts::OrientationValues;
use crate::structs::drawing::charts::Pie3DChart;
use crate::structs::drawing::charts::PieChart;
use crate::structs::drawing::charts::PlotArea;
use crate::structs::drawing::charts::PrintSettings;
use crate::structs::drawing::charts::RadarChart;
use crate::structs::drawing::charts::RightAngleAxes;
use crate::structs::drawing::charts::RotateX;
use crate::structs::drawing::charts::RotateY;
use crate::structs::drawing::charts::ScatterChart;
use crate::structs::drawing::charts::SeriesText;
use crate::structs::drawing::charts::ShapeValues;
use crate::structs::drawing::charts::ShowLeaderLines;
use crate::structs::drawing::charts::Smooth;
use crate::structs::drawing::charts::StringLiteral;
use crate::structs::drawing::charts::StringPoint;
use crate::structs::drawing::charts::StringReference;
use crate::structs::drawing::charts::TextProperties;
use crate::structs::drawing::charts::TickLabelPositionValues;
use crate::structs::drawing::charts::TickMarkValues;
use crate::structs::drawing::charts::Title;
use crate::structs::drawing::charts::ValueAxis;
use crate::structs::drawing::charts::Values;
use crate::structs::drawing::charts::View3D;
use crate::structs::drawing::charts::XValues;
use crate::structs::drawing::charts::YValues;
use crate::structs::drawing::spreadsheet::GraphicFrame;
use crate::structs::drawing::spreadsheet::MarkerType;
use crate::structs::drawing::spreadsheet::TwoCellAnchor;
use crate::structs::drawing::Paragraph;
use crate::structs::drawing::Run;
use crate::structs::drawing::RunProperties;
use crate::structs::rich_text;
use crate::structs::ChartType;
use crate::traits::AdjustmentCoordinate;
use crate::traits::AdjustmentCoordinateWithSheet;

/// ## Supported chart types
/// * AreaChart
/// * Area3DChart
/// * BarChart
/// * Bar3DChart
/// * BubbleChart
/// * DoughnutChart
/// * LineChart
/// * Line3DChart
/// * OfPieChart
/// * PieChart
/// * RadarChart
/// * ScatterChart
///
/// Other types will be supported sequentially.
///
/// ## Example
/// ![Result Image](https://github.com/MathNya/umya-spreadsheet/raw/master/images/chart/chart_title.png)
/// ```rust
/// extern crate umya_spreadsheet;
/// let mut book = umya_spreadsheet::new_file();
///
/// // Add Chart
/// let mut from_marker = umya_spreadsheet::structs::drawing::spreadsheet::MarkerType::default();
/// let mut to_marker = umya_spreadsheet::structs::drawing::spreadsheet::MarkerType::default();
/// from_marker.set_coordinate("C1");
/// to_marker.set_coordinate("D11");
/// let area_chart_series_list = vec![
///     "Sheet1!$A$1:$A$10",
///     "Sheet1!$B$1:$B$10",
/// ];
/// let mut chart = umya_spreadsheet::structs::Chart::default();
/// chart.new_chart(
///     umya_spreadsheet::structs::ChartType::LineChart,
///     from_marker,
///     to_marker,
///     area_chart_series_list,
/// );
/// book.get_sheet_by_name_mut("Sheet1").unwrap()
///     .add_chart(chart);
///
/// // Get Chart by Worksheet.
/// let mut worksheet = book.get_sheet_by_name_mut("Sheet1").unwrap();
/// let chart = worksheet.get_chart("C1");
/// let chart = worksheet.get_chart_by_column_and_row(&3, &1);
/// let chart = worksheet.get_chart_mut("C1");
/// let chart = worksheet.get_chart_by_column_and_row_mut(&3, &1);
///
/// // Use this if there are multiple Charts in a given cell.
/// let charts = worksheet.get_charts("C1");
/// let charts = worksheet.get_charts_by_column_and_row(&3, &1);
/// let charts = worksheet.get_charts_mut("C1");
/// let charts = worksheet.get_charts_by_column_and_row_mut(&3, &1);
///
/// // Set Chart Title, Series Title, Horizonal Title and Vertical Title.
/// let mut chart = book.get_sheet_by_name_mut("Sheet1").unwrap().get_chart_mut("C1").unwrap();
/// chart
///     .set_series_title(vec!["Line1", "Line2"])
///     .set_series_point_title(vec!["Point1", "Point2", "Point3", "Point4"])
///     .set_title("Chart Title")
///     .set_horizontal_title("Horizontal Title")
///     .set_vertical_title("Vertical Title");
///
/// // line chart is a stack line chart by default.
/// // To change it to an actual line chart, configure as follows
/// chart
///     .set_grouping(umya_spreadsheet::drawing::charts::GroupingValues::Standard);
/// ```
#[derive(Clone, Debug)]
pub struct Chart {
    two_cell_anchor: Box<TwoCellAnchor>,
    default_language: String,
}

impl Default for Chart {
    #[inline]
    fn default() -> Self {
        Self {
            two_cell_anchor: Box::new(TwoCellAnchor::default()),
            default_language: "en-GB".into(),
        }
    }
}
impl Chart {
    #[inline]
    pub fn set_title<S: Into<String>>(&mut self, value: S) -> &mut Self {
        let title = self.make_title(value);
        self.get_chart_space_mut().get_chart_mut().set_title(title);
        self
    }

    #[inline]
    pub fn set_grouping(&mut self, value: GroupingValues) -> &mut Self {
        self.get_plot_area_mut().set_grouping(value);
        self
    }

    pub fn set_vertical_title<S: Into<String>>(&mut self, value: S) -> &mut Self {
        let title = self.make_title(value);
        let plot_area = self.get_plot_area_mut();
        match plot_area.get_value_axis_mut().len() {
            1 => {
                if let Some(v) = plot_area.get_value_axis_mut().get_mut(0) {
                    v.set_title(title);
                }
            }
            2 => {
                if let Some(v) = plot_area.get_value_axis_mut().get_mut(1) {
                    v.set_title(title);
                }
            }
            _ => {}
        }
        self
    }

    pub fn set_horizontal_title<S: Into<String>>(&mut self, value: S) -> &mut Self {
        let title = self.make_title(value);
        let plot_area = self.get_plot_area_mut();
        match plot_area.get_value_axis_mut().len() {
            1 => {
                if let Some(v) = plot_area.get_category_axis_mut().get_mut(0) {
                    v.set_title(title);
                }
            }
            2 => {
                if let Some(v) = plot_area.get_value_axis_mut().get_mut(0) {
                    v.set_title(title);
                }
            }
            _ => {}
        }
        self
    }

    pub fn set_series_title<S: Into<String>>(&mut self, value: Vec<S>) -> &mut Self {
        let mut value_iter = value.into_iter().map(Into::into);
        for series in self
            .get_area_chart_series_list_mut()
            .get_area_chart_series_mut()
        {
            let value_raw = value_iter.next();
            if let Some(v) = value_raw {
                let mut chart_text = ChartText::default();
                let mut numeric_value = NumericValue::default();
                numeric_value.set_text(v);
                chart_text.set_numeric_value(numeric_value);
                series.set_chart_text(chart_text);
            }
        }
        self
    }

    pub fn set_series_point_title<S: Into<String>>(&mut self, value: Vec<S>) -> &mut Self {
        let mut string_literal = StringLiteral::default();
        for v in value {
            let mut string_point = StringPoint::default();
            string_point.get_numeric_value_mut().set_text(v);
            string_literal.add_string_point_list(string_point);
        }
        for series in self
            .get_area_chart_series_list_mut()
            .get_area_chart_series_mut()
        {
            match series.get_category_axis_data_mut() {
                Some(v) => {
                    v.remove_string_reference();
                    v.set_string_literal(string_literal.clone());
                }
                None => {
                    let mut obj = CategoryAxisData::default();
                    obj.set_string_literal(string_literal.clone());
                    series.set_category_axis_data(obj);
                }
            }
        }
        self
    }

    #[inline]
    pub fn get_plot_area_mut(&mut self) -> &mut PlotArea {
        self.get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
    }

    #[inline]
    pub fn get_area_chart_series_list_mut(&mut self) -> &mut AreaChartSeriesList {
        self.get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .get_area_chart_series_list_mut()
    }

    #[inline]
    pub fn get_two_cell_anchor(&self) -> &TwoCellAnchor {
        &self.two_cell_anchor
    }

    #[inline]
    pub fn get_two_cell_anchor_mut(&mut self) -> &mut TwoCellAnchor {
        &mut self.two_cell_anchor
    }

    #[inline]
    pub fn set_two_cell_anchor(&mut self, value: TwoCellAnchor) -> &mut Self {
        self.two_cell_anchor = Box::new(value);
        self
    }

    #[inline]
    pub fn set_default_language<S: Into<String>>(&mut self, value: S) -> &mut Self {
        self.default_language = value.into();
        self
    }

    pub fn get_chart_space(&self) -> &ChartSpace {
        self.two_cell_anchor
            .get_graphic_frame()
            .expect("Non-ChartSpace.")
            .get_graphic()
            .get_graphic_data()
            .get_chart_space()
    }

    pub fn get_chart_space_mut(&mut self) -> &mut ChartSpace {
        self.two_cell_anchor
            .get_graphic_frame_mut()
            .expect("Non-ChartSpace.")
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
    }

    pub fn new_chart(
        &mut self,
        chart_type: ChartType,
        from_marker: MarkerType,
        to_marker: MarkerType,
        area_chart_series_list: Vec<&str>,
    ) -> &mut Self {
        self.two_cell_anchor.set_from_marker(from_marker);
        self.two_cell_anchor.set_to_marker(to_marker);

        match chart_type {
            ChartType::LineChart => {
                self.new_chart_line_chart(area_chart_series_list);
            }
            ChartType::Line3DChart => {
                self.new_chart_line_3d_chart(area_chart_series_list);
            }
            ChartType::PieChart => {
                self.new_chart_pie_chart(area_chart_series_list);
            }
            ChartType::Pie3DChart => {
                self.new_chart_pie_3d_chart(area_chart_series_list);
            }
            ChartType::DoughnutChart => {
                self.new_chart_doughnut_chart(area_chart_series_list);
            }
            ChartType::AreaChart => {
                self.new_chart_area_chart(area_chart_series_list);
            }
            ChartType::Area3DChart => {
                self.new_chart_area_3d_chart(area_chart_series_list);
            }
            ChartType::BarChart => {
                self.new_chart_bar_chart(area_chart_series_list);
            }
            ChartType::Bar3DChart => {
                self.new_chart_bar_3d_chart(area_chart_series_list);
            }
            ChartType::OfPieChart => {
                self.new_chart_of_pie_chart(area_chart_series_list);
            }
            ChartType::BubbleChart => {
                self.new_chart_bubble_chart(area_chart_series_list);
            }
            ChartType::RadarChart => {
                self.new_chart_radar_chart(area_chart_series_list);
            }
            ChartType::ScatterChart => {
                self.new_chart_scatter_chart(area_chart_series_list);
            }
        }

        self
    }

    #[inline]
    pub fn get_coordinate(&self) -> String {
        self.two_cell_anchor.get_from_marker().get_coordinate()
    }

    #[inline]
    pub(crate) fn get_col(&self) -> &u32 {
        self.two_cell_anchor.get_from_marker().get_col()
    }

    #[inline]
    pub(crate) fn get_row(&self) -> &u32 {
        self.two_cell_anchor.get_from_marker().get_row()
    }

    fn convert_series(
        &self,
        area_chart_series_list: Vec<&str>,
        smooth: bool,
    ) -> AreaChartSeriesList {
        let mut acsl_obj = AreaChartSeriesList::default();
        area_chart_series_list
            .into_iter()
            .enumerate()
            .for_each(|(idx, area_chart_series)| {
                let mut values = Values::default();
                values
                    .get_number_reference_mut()
                    .get_formula_mut()
                    .set_address_str(area_chart_series);
                values
                    .get_number_reference_mut()
                    .get_numbering_cache_mut()
                    .get_format_code_mut()
                    .set_text("General");

                let mut acs_obj = AreaChartSeries::default();
                acs_obj.get_index_mut().set_val(idx as u32);
                acs_obj.get_order_mut().set_val(idx as u32);
                acs_obj.set_values(values);
                if smooth {
                    acs_obj.set_smooth(Smooth::default());
                } else {
                    let mut invert_if_negative = InvertIfNegative::default();
                    invert_if_negative.set_val(0f64);
                    acs_obj.set_invert_if_negative(invert_if_negative);
                }
                acsl_obj.add_area_chart_series(acs_obj);
            });
        acsl_obj
    }

    pub(crate) fn new_chart_line_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let acsl_obj = self.convert_series(area_chart_series_list, true);

        let mut axis_id1 = AxisId::default();
        axis_id1.set_val(213468160);

        let mut axis_id2 = AxisId::default();
        axis_id2.set_val(169590080);

        let mut line_chart = LineChart::default();
        line_chart
            .get_grouping_mut()
            .set_val(GroupingValues::Stacked);
        line_chart.set_area_chart_series_list(acsl_obj);
        line_chart.get_show_marker_mut().set_val(true);
        line_chart.add_axis_id(axis_id1);
        line_chart.add_axis_id(axis_id2);

        let mut category_axis = CategoryAxis::default();
        category_axis.get_axis_id_mut().set_val(213468160);
        category_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        category_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::None);
        category_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        category_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        category_axis
            .get_tick_crossing_axis_mut()
            .set_val(169590080);
        category_axis.get_auto_labeled_mut().set_val(true);
        category_axis.get_label_offset_mut().set_val(100);

        let major_gridlines = MajorGridlines::default();

        let mut value_axis = ValueAxis::default();
        value_axis.get_axis_id_mut().set_val(169590080);
        value_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        value_axis
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Left);
        value_axis.set_major_gridlines(major_gridlines);
        value_axis
            .get_numbering_format_mut()
            .set_format_code("General");
        value_axis
            .get_numbering_format_mut()
            .set_source_linked(true);
        value_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        value_axis.get_tick_crossing_axis_mut().set_val(213468160);

        let layout = Layout::default();
        let mut style = Style::default();
        style.set_val('2');

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_line_chart(line_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_category_axis(category_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_value_axis(value_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .set_layout(layout);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Zero);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_line_3d_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let mut rotate_x = RotateX::default();
        let mut rotate_y = RotateY::default();
        let mut right_angle_axes = RightAngleAxes::default();
        rotate_x.set_val(15);
        rotate_y.set_val(10);
        right_angle_axes.set_val(true);
        let mut view_3d = View3D::default();
        view_3d.set_rotate_x(rotate_x);
        view_3d.set_rotate_y(rotate_y);
        view_3d.set_right_angle_axes(right_angle_axes);

        let acsl_obj = self.convert_series(area_chart_series_list, true);

        let mut axis_id1 = AxisId::default();
        axis_id1.set_val(213468160);

        let mut axis_id2 = AxisId::default();
        axis_id2.set_val(169590080);

        let mut line_3d_chart = Line3DChart::default();
        line_3d_chart
            .get_grouping_mut()
            .set_val(GroupingValues::Stacked);
        line_3d_chart.set_area_chart_series_list(acsl_obj);
        line_3d_chart.add_axis_id(axis_id1);
        line_3d_chart.add_axis_id(axis_id2);

        let mut category_axis = CategoryAxis::default();
        category_axis.get_axis_id_mut().set_val(213468160);
        category_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        category_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::None);
        category_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        category_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        category_axis
            .get_tick_crossing_axis_mut()
            .set_val(169590080);
        category_axis.get_auto_labeled_mut().set_val(true);
        category_axis.get_label_offset_mut().set_val(100);

        let major_gridlines = MajorGridlines::default();

        let mut value_axis = ValueAxis::default();
        value_axis.get_axis_id_mut().set_val(169590080);
        value_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        value_axis
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Left);
        value_axis.set_major_gridlines(major_gridlines);
        value_axis
            .get_numbering_format_mut()
            .set_format_code("General");
        value_axis
            .get_numbering_format_mut()
            .set_source_linked(true);
        value_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        value_axis.get_tick_crossing_axis_mut().set_val(213468160);

        let layout = Layout::default();
        let mut style = Style::default();
        style.set_val('2');

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .set_view_3d(view_3d);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_line_3d_chart(line_3d_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_category_axis(category_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_value_axis(value_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .set_layout(layout);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Zero);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_pie_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let acsl_obj = self.convert_series(area_chart_series_list, true);

        let mut show_leader_lines = ShowLeaderLines::default();
        show_leader_lines.set_val(true);

        let mut pie_chart = PieChart::default();
        pie_chart.get_vary_colors_mut().set_val(true);
        pie_chart.set_area_chart_series_list(acsl_obj);
        pie_chart
            .get_data_labels_mut()
            .set_show_leader_lines(show_leader_lines);

        let layout = Layout::default();
        let mut style = Style::default();
        style.set_val('2');

        let default_run_properties = RunProperties::default();
        let mut end_paragraph_run_properties = RunProperties::default();
        end_paragraph_run_properties.set_language(&self.default_language);
        let mut paragraph = Paragraph::default();
        paragraph
            .get_paragraph_properties_mut()
            .set_right_to_left("0");
        paragraph
            .get_paragraph_properties_mut()
            .set_default_run_properties(default_run_properties);
        paragraph.set_end_para_run_properties(end_paragraph_run_properties);

        let mut text_properties = TextProperties::default();
        text_properties.add_paragraph(paragraph);

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_pie_chart(pie_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .set_layout(layout);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .set_text_properties(text_properties);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Gap);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_pie_3d_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let mut rotate_x = RotateX::default();
        let mut rotate_y = RotateY::default();
        let mut right_angle_axes = RightAngleAxes::default();
        rotate_x.set_val(15);
        rotate_y.set_val(10);
        right_angle_axes.set_val(true);
        let mut view_3d = View3D::default();
        view_3d.set_rotate_x(rotate_x);
        view_3d.set_rotate_y(rotate_y);
        view_3d.set_right_angle_axes(right_angle_axes);

        let acsl_obj = self.convert_series(area_chart_series_list, true);

        let mut show_leader_lines = ShowLeaderLines::default();
        show_leader_lines.set_val(true);

        let mut pie_3d_chart = Pie3DChart::default();
        pie_3d_chart.get_vary_colors_mut().set_val(true);
        pie_3d_chart.set_area_chart_series_list(acsl_obj);
        pie_3d_chart
            .get_data_labels_mut()
            .set_show_leader_lines(show_leader_lines);

        let layout = Layout::default();
        let mut style = Style::default();
        style.set_val('2');

        let default_run_properties = RunProperties::default();
        let mut end_paragraph_run_properties = RunProperties::default();
        end_paragraph_run_properties.set_language(&self.default_language);
        let mut paragraph = Paragraph::default();
        paragraph
            .get_paragraph_properties_mut()
            .set_right_to_left("0");
        paragraph
            .get_paragraph_properties_mut()
            .set_default_run_properties(default_run_properties);
        paragraph.set_end_para_run_properties(end_paragraph_run_properties);

        let mut text_properties = TextProperties::default();
        text_properties.add_paragraph(paragraph);

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .set_view_3d(view_3d);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_pie_3d_chart(pie_3d_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .set_layout(layout);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .set_text_properties(text_properties);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Gap);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_doughnut_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let mut acsl_obj = AreaChartSeriesList::default();
        let mut acs_obj = AreaChartSeries::default();
        let mut idx = 0;
        let mut ptn = 0;
        for area_chart_series in area_chart_series_list {
            if ptn == 0 {
                let mut string_reference = StringReference::default();
                string_reference
                    .get_formula_mut()
                    .set_address_str(area_chart_series);

                let mut category_axis_data = CategoryAxisData::default();
                category_axis_data.set_string_reference(string_reference);
                acs_obj.set_category_axis_data(category_axis_data);

                ptn += 1;
            } else if ptn == 1 {
                let mut values = Values::default();
                values
                    .get_number_reference_mut()
                    .get_formula_mut()
                    .set_address_str(area_chart_series);
                values
                    .get_number_reference_mut()
                    .get_numbering_cache_mut()
                    .get_format_code_mut()
                    .set_text("General");
                acs_obj.set_values(values);

                acs_obj.get_index_mut().set_val(idx);
                acs_obj.get_order_mut().set_val(idx);
                acsl_obj.add_area_chart_series(acs_obj);

                acs_obj = AreaChartSeries::default();
                idx += 1;
                ptn = 0;
            }
        }

        let mut show_leader_lines = ShowLeaderLines::default();
        show_leader_lines.set_val(true);

        let mut doughnut_chart = DoughnutChart::default();
        doughnut_chart.get_vary_colors_mut().set_val(true);
        doughnut_chart.set_area_chart_series_list(acsl_obj);
        doughnut_chart
            .get_data_labels_mut()
            .set_show_leader_lines(show_leader_lines);
        doughnut_chart.get_hole_size_mut().set_val(50);

        let layout = Layout::default();
        let mut style = Style::default();
        style.set_val('2');

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_doughnut_chart(doughnut_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .set_layout(layout);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Gap);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_area_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let acsl_obj = self.convert_series(area_chart_series_list, true);

        let mut axis_id1 = AxisId::default();
        axis_id1.set_val(213468160);

        let mut axis_id2 = AxisId::default();
        axis_id2.set_val(169590080);

        let mut area_chart = AreaChart::default();
        area_chart
            .get_grouping_mut()
            .set_val(GroupingValues::Standard);
        area_chart.set_area_chart_series_list(acsl_obj);
        area_chart.add_axis_id(axis_id1);
        area_chart.add_axis_id(axis_id2);

        let mut category_axis = CategoryAxis::default();
        category_axis.get_axis_id_mut().set_val(213468160);
        category_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        category_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        category_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        category_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        category_axis
            .get_tick_crossing_axis_mut()
            .set_val(169590080);
        category_axis.get_auto_labeled_mut().set_val(true);
        category_axis.get_label_offset_mut().set_val(100);

        let major_gridlines = MajorGridlines::default();

        let mut value_axis = ValueAxis::default();
        value_axis.get_axis_id_mut().set_val(169590080);
        value_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        value_axis
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Left);
        value_axis.set_major_gridlines(major_gridlines);
        value_axis
            .get_numbering_format_mut()
            .set_format_code("General");
        value_axis
            .get_numbering_format_mut()
            .set_source_linked(true);
        value_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        value_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        value_axis.get_tick_crossing_axis_mut().set_val(213468160);
        value_axis
            .get_cross_between_mut()
            .set_val(CrossBetweenValues::MidpointCategory);

        let mut style = Style::default();
        style.set_val('2');

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_area_chart(area_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_category_axis(category_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_value_axis(value_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Zero);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_area_3d_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let mut rotate_x = RotateX::default();
        let mut rotate_y = RotateY::default();
        let mut right_angle_axes = RightAngleAxes::default();
        rotate_x.set_val(15);
        rotate_y.set_val(10);
        right_angle_axes.set_val(true);
        let mut view_3d = View3D::default();
        view_3d.set_rotate_x(rotate_x);
        view_3d.set_rotate_y(rotate_y);
        view_3d.set_right_angle_axes(right_angle_axes);

        let acsl_obj = self.convert_series(area_chart_series_list, true);

        let mut axis_id1 = AxisId::default();
        axis_id1.set_val(213468160);

        let mut axis_id2 = AxisId::default();
        axis_id2.set_val(169590080);

        let mut area_3d_chart = Area3DChart::default();
        area_3d_chart
            .get_grouping_mut()
            .set_val(GroupingValues::Standard);
        area_3d_chart.set_area_chart_series_list(acsl_obj);
        area_3d_chart.add_axis_id(axis_id1);
        area_3d_chart.add_axis_id(axis_id2);

        let mut category_axis = CategoryAxis::default();
        category_axis.get_axis_id_mut().set_val(213468160);
        category_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        category_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        category_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        category_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        category_axis
            .get_tick_crossing_axis_mut()
            .set_val(169590080);
        category_axis.get_auto_labeled_mut().set_val(true);
        category_axis.get_label_offset_mut().set_val(100);

        let major_gridlines = MajorGridlines::default();

        let mut value_axis = ValueAxis::default();
        value_axis.get_axis_id_mut().set_val(169590080);
        value_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        value_axis
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Left);
        value_axis.set_major_gridlines(major_gridlines);
        value_axis
            .get_numbering_format_mut()
            .set_format_code("General");
        value_axis
            .get_numbering_format_mut()
            .set_source_linked(true);
        value_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        value_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        value_axis.get_tick_crossing_axis_mut().set_val(213468160);
        value_axis
            .get_cross_between_mut()
            .set_val(CrossBetweenValues::MidpointCategory);

        let mut style = Style::default();
        style.set_val('2');

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .set_view_3d(view_3d);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_area_3d_chart(area_3d_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_category_axis(category_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_value_axis(value_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Zero);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_bar_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let acsl_obj = self.convert_series(area_chart_series_list, false);

        let mut axis_id1 = AxisId::default();
        axis_id1.set_val(213468160);

        let mut axis_id2 = AxisId::default();
        axis_id2.set_val(169590080);

        let mut bar_chart = BarChart::default();
        bar_chart
            .get_bar_direction_mut()
            .set_val(BarDirectionValues::Column);
        bar_chart
            .get_grouping_mut()
            .set_val(GroupingValues::Stacked);
        bar_chart.set_area_chart_series_list(acsl_obj);
        bar_chart.get_gap_width_mut().set_val(150);
        bar_chart.get_overlap_mut().set_val(100);
        bar_chart.add_axis_id(axis_id1);
        bar_chart.add_axis_id(axis_id2);

        let mut category_axis = CategoryAxis::default();
        category_axis.get_axis_id_mut().set_val(213468160);
        category_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        category_axis
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Bottom);
        category_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        category_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        category_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        category_axis
            .get_tick_crossing_axis_mut()
            .set_val(169590080);
        category_axis.get_auto_labeled_mut().set_val(true);
        category_axis.get_label_offset_mut().set_val(100);

        let major_gridlines = MajorGridlines::default();

        let mut value_axis = ValueAxis::default();
        value_axis.get_axis_id_mut().set_val(169590080);
        value_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        value_axis
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Left);
        value_axis.set_major_gridlines(major_gridlines);
        value_axis
            .get_numbering_format_mut()
            .set_format_code("General");
        value_axis
            .get_numbering_format_mut()
            .set_source_linked(true);
        value_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        value_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        value_axis.get_tick_crossing_axis_mut().set_val(213468160);

        let mut style = Style::default();
        style.set_val('2');

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_bar_chart(bar_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_category_axis(category_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_value_axis(value_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Gap);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_bar_3d_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let mut rotate_x = RotateX::default();
        let mut rotate_y = RotateY::default();
        let mut right_angle_axes = RightAngleAxes::default();
        rotate_x.set_val(15);
        rotate_y.set_val(10);
        right_angle_axes.set_val(true);
        let mut view_3d = View3D::default();
        view_3d.set_rotate_x(rotate_x);
        view_3d.set_rotate_y(rotate_y);
        view_3d.set_right_angle_axes(right_angle_axes);

        let acsl_obj = self.convert_series(area_chart_series_list, false);

        let mut axis_id1 = AxisId::default();
        axis_id1.set_val(213468160);

        let mut axis_id2 = AxisId::default();
        axis_id2.set_val(169590080);

        let mut bar_3d_chart = Bar3DChart::default();
        bar_3d_chart
            .get_bar_direction_mut()
            .set_val(BarDirectionValues::Column);
        bar_3d_chart
            .get_grouping_mut()
            .set_val(GroupingValues::Stacked);
        bar_3d_chart.set_area_chart_series_list(acsl_obj);
        bar_3d_chart.get_gap_width_mut().set_val(150);
        bar_3d_chart.get_shape_mut().set_val(ShapeValues::Box);
        bar_3d_chart.add_axis_id(axis_id1);
        bar_3d_chart.add_axis_id(axis_id2);

        let mut category_axis = CategoryAxis::default();
        category_axis.get_axis_id_mut().set_val(213468160);
        category_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        category_axis
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Bottom);
        category_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        category_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        category_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        category_axis
            .get_tick_crossing_axis_mut()
            .set_val(169590080);
        category_axis.get_auto_labeled_mut().set_val(true);
        category_axis.get_label_offset_mut().set_val(100);

        let major_gridlines = MajorGridlines::default();

        let mut value_axis = ValueAxis::default();
        value_axis.get_axis_id_mut().set_val(169590080);
        value_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        value_axis
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Left);
        value_axis.set_major_gridlines(major_gridlines);
        value_axis
            .get_numbering_format_mut()
            .set_format_code("General");
        value_axis
            .get_numbering_format_mut()
            .set_source_linked(true);
        value_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        value_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        value_axis.get_tick_crossing_axis_mut().set_val(213468160);

        let mut style = Style::default();
        style.set_val('2');

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .set_view_3d(view_3d);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_bar_3d_chart(bar_3d_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_category_axis(category_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_value_axis(value_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Gap);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_of_pie_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let acsl_obj = self.convert_series(area_chart_series_list, false);

        let mut show_leader_lines = ShowLeaderLines::default();
        show_leader_lines.set_val(true);

        let mut of_pie_chart = OfPieChart::default();
        of_pie_chart.get_of_pie_type_mut().set_val(OfPieValues::Bar);
        of_pie_chart.get_vary_colors_mut().set_val(true);
        of_pie_chart.set_area_chart_series_list(acsl_obj);
        of_pie_chart
            .get_data_labels_mut()
            .set_show_leader_lines(show_leader_lines);

        let default_run_properties = RunProperties::default();
        let mut end_paragraph_run_properties = RunProperties::default();
        end_paragraph_run_properties.set_language(&self.default_language);
        let mut paragraph = Paragraph::default();
        paragraph
            .get_paragraph_properties_mut()
            .set_right_to_left("0");
        paragraph
            .get_paragraph_properties_mut()
            .set_default_run_properties(default_run_properties);
        paragraph.set_end_para_run_properties(end_paragraph_run_properties);

        let mut text_properties = TextProperties::default();
        text_properties.add_paragraph(paragraph);

        let mut style = Style::default();
        style.set_val('2');

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_of_pie_chart(of_pie_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .set_text_properties(text_properties);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Gap);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_bubble_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let mut acsl_obj = AreaChartSeriesList::default();
        let mut acs_obj = AreaChartSeries::default();
        let mut idx = 0;
        let mut ptn = 0;
        for area_chart_series in area_chart_series_list {
            if ptn == 0 {
                let mut x_values = XValues::default();
                x_values
                    .get_number_reference_mut()
                    .get_formula_mut()
                    .set_address_str(area_chart_series);
                x_values
                    .get_number_reference_mut()
                    .get_numbering_cache_mut()
                    .get_format_code_mut()
                    .set_text("General");
                acs_obj.set_x_values(x_values);

                ptn += 1;
            } else if ptn == 1 {
                let mut y_values = YValues::default();
                y_values
                    .get_number_reference_mut()
                    .get_formula_mut()
                    .set_address_str(area_chart_series);
                y_values
                    .get_number_reference_mut()
                    .get_numbering_cache_mut()
                    .get_format_code_mut()
                    .set_text("General");
                acs_obj.set_y_values(y_values);

                ptn += 1;
            } else if ptn == 2 {
                let mut bubble_size = BubbleSize::default();
                bubble_size
                    .get_number_reference_mut()
                    .get_formula_mut()
                    .set_address_str(area_chart_series);
                bubble_size
                    .get_number_reference_mut()
                    .get_numbering_cache_mut()
                    .get_format_code_mut()
                    .set_text("General");
                acs_obj.set_bubble_size(bubble_size);

                let mut invert_if_negative = InvertIfNegative::default();
                invert_if_negative.set_val(0f64);

                let bubble_3d = Bubble3D::default();

                acs_obj.get_index_mut().set_val(idx);
                acs_obj.get_order_mut().set_val(idx);
                acs_obj.set_invert_if_negative(invert_if_negative);
                acs_obj.set_bubble_3d(bubble_3d);
                acsl_obj.add_area_chart_series(acs_obj);

                acs_obj = AreaChartSeries::default();
                ptn = 0;
                idx += 1;
            }
        }

        let mut show_leader_lines = ShowLeaderLines::default();
        show_leader_lines.set_val(true);

        let mut axis_id1 = AxisId::default();
        axis_id1.set_val(213468160);

        let mut axis_id2 = AxisId::default();
        axis_id2.set_val(169590080);

        let mut bubble_chart = BubbleChart::default();
        bubble_chart.get_vary_colors_mut().set_val(false);
        bubble_chart.set_area_chart_series_list(acsl_obj);
        bubble_chart.get_bubble_scale_mut().set_val(100);
        bubble_chart.add_axis_id(axis_id1);
        bubble_chart.add_axis_id(axis_id2);
        bubble_chart
            .get_data_labels_mut()
            .set_show_leader_lines(show_leader_lines);

        let mut value_axis_1 = ValueAxis::default();
        value_axis_1.get_axis_id_mut().set_val(213468160);
        value_axis_1
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        value_axis_1
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Bottom);
        value_axis_1
            .get_numbering_format_mut()
            .set_format_code("General");
        value_axis_1
            .get_numbering_format_mut()
            .set_source_linked(true);
        value_axis_1
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        value_axis_1
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis_1
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        value_axis_1.get_tick_crossing_axis_mut().set_val(169590080);
        value_axis_1
            .get_cross_between_mut()
            .set_val(CrossBetweenValues::MidpointCategory);

        let major_gridlines = MajorGridlines::default();
        let mut value_axis_2 = ValueAxis::default();
        value_axis_2.get_axis_id_mut().set_val(169590080);
        value_axis_2
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        value_axis_2
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Left);
        value_axis_2.set_major_gridlines(major_gridlines);
        value_axis_2
            .get_numbering_format_mut()
            .set_format_code("General");
        value_axis_2
            .get_numbering_format_mut()
            .set_source_linked(true);
        value_axis_2
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        value_axis_2
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis_2
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        value_axis_2.get_tick_crossing_axis_mut().set_val(213468160);
        value_axis_2
            .get_cross_between_mut()
            .set_val(CrossBetweenValues::MidpointCategory);

        let default_run_properties = RunProperties::default();
        let mut end_paragraph_run_properties = RunProperties::default();
        end_paragraph_run_properties.set_language(&self.default_language);
        let mut paragraph = Paragraph::default();
        paragraph
            .get_paragraph_properties_mut()
            .set_right_to_left("0");
        paragraph
            .get_paragraph_properties_mut()
            .set_default_run_properties(default_run_properties);
        paragraph.set_end_para_run_properties(end_paragraph_run_properties);

        let mut text_properties = TextProperties::default();
        text_properties.add_paragraph(paragraph);

        let mut style = Style::default();
        style.set_val('2');

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_bubble_chart(bubble_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_value_axis(value_axis_1);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_value_axis(value_axis_2);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .set_text_properties(text_properties);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Gap);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_radar_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let acsl_obj = self.convert_series(area_chart_series_list, true);

        let mut axis_id1 = AxisId::default();
        axis_id1.set_val(213468160);

        let mut axis_id2 = AxisId::default();
        axis_id2.set_val(169590080);

        let mut radar_chart = RadarChart::default();
        radar_chart.set_area_chart_series_list(acsl_obj);
        radar_chart.add_axis_id(axis_id1);
        radar_chart.add_axis_id(axis_id2);

        let mut category_axis = CategoryAxis::default();
        category_axis.get_axis_id_mut().set_val(213468160);
        category_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        category_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::None);
        category_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        category_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        category_axis
            .get_tick_crossing_axis_mut()
            .set_val(169590080);
        category_axis.get_auto_labeled_mut().set_val(true);
        category_axis.get_label_offset_mut().set_val(100);

        let major_gridlines = MajorGridlines::default();

        let mut value_axis = ValueAxis::default();
        value_axis.get_axis_id_mut().set_val(169590080);
        value_axis
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        value_axis
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Left);
        value_axis.set_major_gridlines(major_gridlines);
        value_axis
            .get_numbering_format_mut()
            .set_format_code("General");
        value_axis
            .get_numbering_format_mut()
            .set_source_linked(true);
        value_axis
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        value_axis.get_tick_crossing_axis_mut().set_val(213468160);

        let layout = Layout::default();
        let mut style = Style::default();
        style.set_val('2');

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_radar_chart(radar_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_category_axis(category_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_value_axis(value_axis);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .set_layout(layout);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Zero);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    pub(crate) fn new_chart_scatter_chart(&mut self, area_chart_series_list: Vec<&str>) {
        let mut acsl_obj = AreaChartSeriesList::default();
        let mut acs_obj = AreaChartSeries::default();
        let mut idx = 0;
        let mut ptn = 0;
        for area_chart_series in area_chart_series_list {
            if ptn == 0 {
                let mut x_values = XValues::default();
                x_values
                    .get_number_reference_mut()
                    .get_formula_mut()
                    .set_address_str(area_chart_series);
                x_values
                    .get_number_reference_mut()
                    .get_numbering_cache_mut()
                    .get_format_code_mut()
                    .set_text("General");
                acs_obj.set_x_values(x_values);

                ptn += 1;
            } else if ptn == 1 {
                let mut y_values = YValues::default();
                y_values
                    .get_number_reference_mut()
                    .get_formula_mut()
                    .set_address_str(area_chart_series);
                y_values
                    .get_number_reference_mut()
                    .get_numbering_cache_mut()
                    .get_format_code_mut()
                    .set_text("General");
                acs_obj.set_y_values(y_values);

                let mut invert_if_negative = InvertIfNegative::default();
                invert_if_negative.set_val(0f64);

                acs_obj.get_index_mut().set_val(idx);
                acs_obj.get_order_mut().set_val(idx);
                acs_obj.set_invert_if_negative(invert_if_negative);
                acsl_obj.add_area_chart_series(acs_obj);

                acs_obj = AreaChartSeries::default();
                ptn = 0;
                idx += 1;
            }
        }

        let mut axis_id1 = AxisId::default();
        axis_id1.set_val(213468160);

        let mut axis_id2 = AxisId::default();
        axis_id2.set_val(169590080);

        let mut scatter_chart = ScatterChart::default();
        scatter_chart.set_area_chart_series_list(acsl_obj);
        scatter_chart.add_axis_id(axis_id1);
        scatter_chart.add_axis_id(axis_id2);

        let mut value_axis_1 = ValueAxis::default();
        value_axis_1.get_axis_id_mut().set_val(213468160);
        value_axis_1
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        value_axis_1
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Bottom);
        value_axis_1
            .get_numbering_format_mut()
            .set_format_code("General");
        value_axis_1
            .get_numbering_format_mut()
            .set_source_linked(true);
        value_axis_1
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        value_axis_1
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis_1
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        value_axis_1.get_tick_crossing_axis_mut().set_val(169590080);
        value_axis_1
            .get_cross_between_mut()
            .set_val(CrossBetweenValues::MidpointCategory);

        let major_gridlines = MajorGridlines::default();
        let mut value_axis_2 = ValueAxis::default();
        value_axis_2.get_axis_id_mut().set_val(169590080);
        value_axis_2
            .get_scaling_mut()
            .get_orientation_mut()
            .set_val(OrientationValues::MinMax);
        value_axis_2
            .get_axis_position_mut()
            .set_val(AxisPositionValues::Left);
        value_axis_2.set_major_gridlines(major_gridlines);
        value_axis_2
            .get_numbering_format_mut()
            .set_format_code("General");
        value_axis_2
            .get_numbering_format_mut()
            .set_source_linked(true);
        value_axis_2
            .get_major_tick_mark_mut()
            .set_val(TickMarkValues::Outside);
        value_axis_2
            .get_minor_tick_mark_mut()
            .set_val(TickMarkValues::None);
        value_axis_2
            .get_tick_label_position_mut()
            .set_val(TickLabelPositionValues::NextTo);
        value_axis_2.get_tick_crossing_axis_mut().set_val(213468160);
        value_axis_2
            .get_cross_between_mut()
            .set_val(CrossBetweenValues::MidpointCategory);

        let layout = Layout::default();
        let mut style = Style::default();
        style.set_val('2');

        let mut graphic_frame = GraphicFrame::default();
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_editing_language_mut()
            .set_val(&self.default_language);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .set_scatter_chart(scatter_chart);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_value_axis(value_axis_1);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_area_mut()
            .add_value_axis(value_axis_2);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .get_legend_position_mut()
            .set_val(LegendPositionValues::Right);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_legend_mut()
            .set_layout(layout);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_plot_visible_only_mut()
            .set_val(true);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .get_chart_mut()
            .get_display_blanks_as_mut()
            .set_val(DisplayBlanksAsValues::Zero);
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_print_settings(self.make_print_settings());
        graphic_frame
            .get_graphic_mut()
            .get_graphic_data_mut()
            .get_chart_space_mut()
            .set_style(style);
        self.two_cell_anchor.set_graphic_frame(graphic_frame);
    }

    #[inline]
    pub(crate) fn make_print_settings(&self) -> PrintSettings {
        let mut obj = PrintSettings::default();
        obj.get_page_margins_mut()
            .set_bottom(0.75)
            .set_left(0.7)
            .set_right(0.7)
            .set_top(0.75)
            .set_header(0.3)
            .set_footer(0.3);
        obj
    }

    pub(crate) fn make_title<S: Into<String>>(&self, value: S) -> Title {
        let mut run_properties = RunProperties::default();
        run_properties.set_language(&self.default_language);
        run_properties.set_alternative_language("en-US");

        let mut run = Run::default();
        run.set_run_properties(run_properties);
        run.set_text(value);

        let default_run_properties = RunProperties::default();

        let mut paragraph = Paragraph::default();
        paragraph
            .get_paragraph_properties_mut()
            .set_default_run_properties(default_run_properties);
        paragraph.add_run(run);

        let mut chart_text = ChartText::default();
        let mut rich_text = RichText::default();
        rich_text.add_paragraph(paragraph);
        chart_text.set_rich_text(rich_text);

        let mut title = Title::default();
        title.set_chart_text(chart_text);

        title
    }
}
impl AdjustmentCoordinate for Chart {
    #[inline]
    fn adjustment_insert_coordinate(
        &mut self,
        root_col_num: &u32,
        offset_col_num: &u32,
        root_row_num: &u32,
        offset_row_num: &u32,
    ) {
        self.two_cell_anchor.as_mut().adjustment_insert_coordinate(
            root_col_num,
            offset_col_num,
            root_row_num,
            offset_row_num,
        );
    }

    #[inline]
    fn adjustment_remove_coordinate(
        &mut self,
        root_col_num: &u32,
        offset_col_num: &u32,
        root_row_num: &u32,
        offset_row_num: &u32,
    ) {
        self.two_cell_anchor.as_mut().adjustment_remove_coordinate(
            root_col_num,
            offset_col_num,
            root_row_num,
            offset_row_num,
        );
    }

    #[inline]
    fn is_remove_coordinate(
        &self,
        root_col_num: &u32,
        offset_col_num: &u32,
        root_row_num: &u32,
        offset_row_num: &u32,
    ) -> bool {
        self.two_cell_anchor.as_ref().is_remove_coordinate(
            root_col_num,
            offset_col_num,
            root_row_num,
            offset_row_num,
        )
    }
}
impl AdjustmentCoordinateWithSheet for Chart {
    #[inline]
    fn adjustment_insert_coordinate_with_sheet(
        &mut self,
        sheet_name: &str,
        root_col_num: &u32,
        offset_col_num: &u32,
        root_row_num: &u32,
        offset_row_num: &u32,
    ) {
        self.two_cell_anchor
            .as_mut()
            .adjustment_insert_coordinate_with_sheet(
                sheet_name,
                root_col_num,
                offset_col_num,
                root_row_num,
                offset_row_num,
            );
    }

    #[inline]
    fn adjustment_remove_coordinate_with_sheet(
        &mut self,
        sheet_name: &str,
        root_col_num: &u32,
        offset_col_num: &u32,
        root_row_num: &u32,
        offset_row_num: &u32,
    ) {
        self.two_cell_anchor
            .as_mut()
            .adjustment_insert_coordinate_with_sheet(
                sheet_name,
                root_col_num,
                offset_col_num,
                root_row_num,
                offset_row_num,
            );
    }
}