philryan29
New Member
- Joined
- Jan 22, 2016
- Messages
- 4
Hello,
I am struggling with this one. I have a stacked bar chart to which I have added a data table beneath the chart. Normally, when I change the primary horizontal axis to display as text, it disappears and pulls the data table tight against the bottom of the chart so that the column headers for the table act as the axis. This is very handy because it creates a one-to-one ratio between each data column and the relevant bars above. However, when I change one of the data points to be a plotted line and throw it on a secondary vertical axis, the chart scrunches up in relation to the data table, and the horizontal axis reappears and the one-to-one ratio goes out the window. Becomes a very sloppy presentation.
I have worked around this in the past, but have no idea how I pulled it off and can't see a difference in formatting selections between an old chart and a new one.
Anyone have any thoughts? I am using 2013, btw.
Thanks!
I am struggling with this one. I have a stacked bar chart to which I have added a data table beneath the chart. Normally, when I change the primary horizontal axis to display as text, it disappears and pulls the data table tight against the bottom of the chart so that the column headers for the table act as the axis. This is very handy because it creates a one-to-one ratio between each data column and the relevant bars above. However, when I change one of the data points to be a plotted line and throw it on a secondary vertical axis, the chart scrunches up in relation to the data table, and the horizontal axis reappears and the one-to-one ratio goes out the window. Becomes a very sloppy presentation.
I have worked around this in the past, but have no idea how I pulled it off and can't see a difference in formatting selections between an old chart and a new one.
Anyone have any thoughts? I am using 2013, btw.
Thanks!