Combining Line Chart Data with Bar Plot in TikZ

bar chartchartspgfplotstikz-pgf

Context

I recently got a paper published and was told that I need to convert the word file I submitted to latex for camera ready purposes. Problem is, I don't know LaTeX but I have always wanted to learn it. All is fine and straight forward except for chart creation.

Problem

I created a couple of charts in excel and have successfully converted them to LaTeX except for one. It is a line chart over a bar plot. Like the image attached:

column line chart

Work to date

I have created the following bar plot with pgfplots but I don't know how to add the line chart data in. It should also be noted, this is not a trend line I am looking to achieve.

\vspace{0.6cm}
\begin{tikzpicture}
\begin{axis}[
    title=Title,
    ybar,
    width=7.8cm,
    enlargelimits=0.15,
    legend style={at={(0.5,-0.15)},
      anchor=north,legend columns=-1},
    ylabel={Pages},
    bar width=7mm, y=4mm,
    symbolic x coords={Firm 1, Firm 2, Firm 3, Firm 4, Firm 5},
    xtick=data,
    x tick label style={rotate=45,anchor=east},
    nodes near coords,
    nodes near coords align={vertical},
    ]
\addplot[fill=black!10] coordinates {(Firm 1,3) (Firm 2,7) (Firm 3,8) (Firm 4,13) (Firm 5,16)};
\end{axis}
\end{tikzpicture}
\vspace{0.6cm}

Concise Question

How do I add the line graph data into the bar plot?

Best Answer

You mean something like this: enter image description here

Above picture is obtained by:

\documentclass[border=3mm]{standalone}
    \usepackage{pgfplots}

\begin{document}
    \begin{tikzpicture}
\begin{axis}[
    title=Title,
    width=7.8cm,
    enlargelimits=0.15,
    legend style={at={(0.5,-0.15)},
      anchor=north,legend columns=-1},
    ylabel={Pages},
    bar width=7mm, y=4mm,
    symbolic x coords={Firm 1, Firm 2, Firm 3, Firm 4, Firm 5},
    xtick=data,
    x tick label style={rotate=45,anchor=east},
    nodes near coords align={vertical},
    ]
\addplot[ybar, nodes near coords, fill=black!10] 
    coordinates {(Firm 1,3) (Firm 2,7) (Firm 3,8) (Firm 4,13) (Firm 5,16)};
\addplot[draw=blue,ultra thick,smooth] 
    coordinates {(Firm 1,3) (Firm 2,7) (Firm 3,8) (Firm 4,13) (Firm 5,16)};
\end{axis}
    \end{tikzpicture}
\end{document}

From above MWE follows, that I for line add another \addplot and move definitions of plot types to the addplot.

Related Solutions

PGFPlots – How to Hide Empty Ybars in Bar Charts

You can use

 y filter/.expression={y==0 ? nan : y}

in the options of \addplot.

\documentclass{article}

% ---------------------------------- tikz
\usepackage{pgfplots}          % to print charts
\pgfplotsset{compat=1.12}

\begin{document}

\begin{figure}
  \centering
  \begin{tikzpicture}
    \begin{axis} [
      % general
      ybar,
      scale only axis,
      height=0.5\textwidth,
      width=1.2\textwidth,
      ylabel={\# Dots},
      nodes near coords,
      xlabel={Variation},
      xticklabel style={
        rotate=90,
        anchor=east,
      },
      %enlarge x limits={abs value={3}},
      ]
      \addplot+[y filter/.expression={y==0 ? nan : y}] table [
        x=grade,
        y=value,
      ] {
grade   value
-11 0
-10 0
-9  0
-8  0
-7  0
-6  0
-5  3
-4  1
-3  2
-2  15
-1  11
0   179
1   8
2   1
3   0
4   1
5   2
6   0
7   0
8   0
9   0
10  0
11  0
      };
    \end{axis}
  \end{tikzpicture}
\end{figure}
\end{document}

pgfplots – Using Percentage in PGFPlots Matrix Plot

It does not work in your MWE because you are overwriting it by also giving the option nodes near coors to the \addplot command. Remove the latter one (or specify format here), and it will print. I added a thinspace before the percentage sign, although it can also be recommended to load the siunitx package and let that format and typeset the values for you.

Anyway, here's the quickfixed version:

\documentclass[border=3pt]{standalone}
\usepackage{pgfplots}
\pgfplotsset{%
  width=5cm,
  height=18cm,
  compat=1.13,
  colormap={blackwhite}{gray(0cm)=(1); gray(1cm)=(0.5)},
  xticklabels={LPIBG, ALL, HPIBG},
  xtick={0,...,2},
  ytick=\empty
}

\begin{document}
\begin{tikzpicture}
\begin{axis}[%
  enlargelimits=false,
  xlabel style={font=\footnotesize},
  ylabel style={font=\footnotesize},
  legend style={font=\footnotesize},
  xticklabel style={font=\footnotesize},
  yticklabel style={font=\footnotesize},
  colorbar,
  colorbar style={%
    ytick={0,20,40,60,80,100},
    yticklabels={0,20,40,60,80,100},
    yticklabel={\pgfmathprintnumber\tick\,\%},
    yticklabel style={font=\footnotesize}
  },
  point meta min=0,
  point meta max=100,
  nodes near coords={\pgfmathprintnumber\pgfplotspointmeta\,\%},
  every node near coord/.append style={xshift=0pt,yshift=-7pt, black, font=\footnotesize},
]

\addplot[
matrix plot,
mesh/cols=3,
point meta=explicit]
table[meta=C]{
  x y C
  0 0 80
  1 0 36
  2 0 40
  0 1 64
  1 1 80
  2 1 60
  0 2 52
  1 2 84
  2 2 72
  0 3 72
  1 3 28
  2 3 32
  0 4 56
  1 4 84
  2 4 80
  0 5 72
  1 5 52
  2 5 44
  0 6 4
  1 6 84
  2 6 41
  0 7 37
  1 7 69
  2 7 84
  0 8 63
  1 8 53
  2 8 82
  0 9 78
  1 9 74
  2 9 39
  0 10 39
  1 10 63
  2 10 88
  0 11 76
  1 11 74
  2 11 49
  0 12 39
  1 12 6
  2 12 88
  0 13 46
  1 13 33
  2 13 75
  0 14 88
  1 14 67
  2 14 54
  0 15 79
  1 15 83
  2 15 75
  0 16 50
  1 16 46
  2 16 71
  0 17 92
  1 17 71
  2 17 75
  0 18 46
  1 18 33
  2 18 8
};
\end{axis}
\end{tikzpicture}
\end{document}

Best Answer

Related Solutions

PGFPlots – How to Hide Empty Ybars in Bar Charts

pgfplots – Using Percentage in PGFPlots Matrix Plot

Related Question