Chart with a negative and positive values

  • Thread starter Thread starter ekaitila
  • Start date Start date
E

ekaitila

Hello,

I would like to make a chart where one can see the bars in each side o
the category axis. In one side of the category axis there are positiv
values and in other side negative.

This I can do but what if I would like to have many bars by side an
also a line chart in the same graph?

t:Es
 
Add the line chart data to the graph. XL will add it as a bar. Select
this new bar graph, and select Chart | Chart Type... | appropriate line
+ sub-type. XL will create a secondary x- and secondary y- axes for
this line graph.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top