How to create multiple bar charts from one CSV file

Question

I have the following CSV dow_distribution.csv file:

DoW,ANZ Vol.,CBA Vol.,MQG Vol.,NAB Vol.,WBC Vol.,AORD Vol.,Total Vol.
Monday,3.63,1.93,0.88,3.14,3.56,457.56,470.7
Tuesday,4.11,2.12,0.92,3.64,4.07,520.05,534.92
Wednesday,4.36,2.26,1.02,3.86,4.3,543.45,559.25
Thursday,4.56,2.46,1.07,4.22,4.44,547.04,563.79
Friday,2.47,1.36,0.63,2.22,2.33,292.65,301.67
Saturday,0,0,0,0,0,0,0
Sunday,1.58,0.86,0.35,1.4,1.56,194.2,199.96

I want to create a multiple bar charts from this csv file.

Code:

My code is as follows:

\documentclass[a4paper,14]{report}
\usepackage[utf8]{inputenc}  
\usepackage{csvsimple}
\usepackage{pgfplots}
\usepackage{pgfplotstable}
\usepackage{geometry}
\geometry{
 a4paper,
 total={170mm,257mm},
 left=20mm,
 top=20mm,
 }
\begin{document}

\csvautotabular{dow_distribution.csv}
% Code for graphing ..
\end{document}

Desired Output: close up of the charts

Question:

From one CSV file, how can I generate multiple bar charts, using the first column as a reference for the x axis for all of the graphs, while the remainders will be used as y axis to generate the graphs?

The charts, size wise should all be uniform. The exception is the very last column or the "total vol" column, where this should be a different colour to the rest.

Answer 1

Here I present one way using the groupplots library of PGFPlots. The result is quite near to what you finally want to achieve, so it should be a good start.

For details please have a look at the comments in the code.

% used PGFPlots v1.16
\begin{filecontents*}{dow_distribution.csv}
DoW,ANZ Vol.,CBA Vol.,MQG Vol.,NAB Vol.,WBC Vol.,AORD Vol.,Total Vol.
Monday,3.63,1.93,0.88,3.14,3.56,457.56,470.7
Tuesday,4.11,2.12,0.92,3.64,4.07,520.05,534.92
Wednesday,4.36,2.26,1.02,3.86,4.3,543.45,559.25
Thursday,4.56,2.46,1.07,4.22,4.44,547.04,563.79
Friday,2.47,1.36,0.63,2.22,2.33,292.65,301.67
Saturday,0,0,0,0,0,0,0
Sunday,1.58,0.86,0.35,1.4,1.56,194.2,199.96
\end{filecontents*}
\documentclass[border=5pt]{standalone}
\usepackage{pgfplots}
    \usetikzlibrary{pgfplots.groupplots}
    % use this `compat' level or higher to be able to provide `bar with' in axis units
    \pgfplotsset{compat=1.7}
    % define a command to get the column headers of the CSV file
    \newcommand\ColHeader[1]{
        \pgfplotstableread{dow_distribution.csv}{\table}
        \pgfplotstablegetcolumnnamebyindex{#1}\of{\table}\to{\colname}
        \colname
    }
\begin{document}
\begin{tikzpicture}
    % use the `groupplot' environment to easily get "the same" diagrams
    \begin{groupplot}[
        group style={
            % set the size of the groupplot
            group size=3 by 3,
            % adjust the `vertical sep' so the plots don't overlap
            vertical sep=30mm,
        },
        % adjust that value to fit your needs in your final document
        width=0.4\textwidth,
        ybar,
        /pgf/bar width=1,
        ymin=0,
        % the next two keys provide the desired `xticklabels'
        xtick=data,
        xticklabels from table={dow_distribution.csv}{DoW},
        % adapt the style of the `xticklabels'
        x tick label style={
            rotate=90,
            anchor=east,
        },
        % this is also a key to provide the desired `xticklabels'
        table/x expr=\coordindex,
        table/col sep=comma,
    ]
    % start the first plot
    \nextgroupplot[
        % set the `title' of the plot
        title=\ColHeader{1},
    ]
        % add the data to the plot
        \addplot table [y index=1] {dow_distribution.csv};
    \nextgroupplot[
        title=\ColHeader{2},
    ]
        \addplot table [y index=2] {dow_distribution.csv};
    \nextgroupplot[
        title=\ColHeader{3},
    ]
        \addplot table [y index=3] {dow_distribution.csv};
    \nextgroupplot[
        title=\ColHeader{4},
    ]
        \addplot table [y index=4] {dow_distribution.csv};
    \nextgroupplot[
        title=\ColHeader{5},
    ]
        \addplot table [y index=5] {dow_distribution.csv};
    \nextgroupplot[
        title=\ColHeader{6},
    ]
        \addplot table [y index=6] {dow_distribution.csv};
    \nextgroupplot[
        title=\ColHeader{7},
    ]
            % to change the color of plot here I have chosen to shift the
            % `cycle list index' so you get the style of the 2nd entry in the
            % current used `bar cycle list'
            \pgfplotsset{cycle list shift=1}
        \addplot table [y index=7] {dow_distribution.csv};
    % the last two plots are empty
    \nextgroupplot[group/empty plot]
    \nextgroupplot[group/empty plot]
    \end{groupplot}
\end{tikzpicture}
\end{document}