ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Need to make a plain barchart, not a histogram (https://www.excelbanter.com/charts-charting-excel/51119-need-make-plain-barchart-not-histogram.html)

penguinchick

Need to make a plain barchart, not a histogram
 
I need to create a barchart rather than a histogram and I cannot figure out
how to do this in Excel. The only option listed in the chart wizard for bar
chart displays the bars horizontally, and I do not want that. I want my data
to appear like a histogram but with spaces in between the vertical columns.
Can anyone help?

Thanks!

Mike Middleton

Need to make a plain barchart, not a histogram
 
penguinchick -

Use the Column chart type (vertical bars).

- Mike
www.mikemiddleton.com

"penguinchick" wrote in message
...
I need to create a barchart rather than a histogram and I cannot figure out
how to do this in Excel. The only option listed in the chart wizard for
bar
chart displays the bars horizontally, and I do not want that. I want my
data
to appear like a histogram but with spaces in between the vertical
columns.
Can anyone help?

Thanks!




Jon Peltier

Need to make a plain barchart, not a histogram
 
Right above the icon for horizontal bars is the one for vertical columns.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


penguinchick wrote:

I need to create a barchart rather than a histogram and I cannot figure out
how to do this in Excel. The only option listed in the chart wizard for bar
chart displays the bars horizontally, and I do not want that. I want my data
to appear like a histogram but with spaces in between the vertical columns.
Can anyone help?

Thanks!



All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com