ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I change the chart so date is up and down and data is acro (https://www.excelbanter.com/charts-charting-excel/41875-how-can-i-change-chart-so-date-up-down-data-acro.html)

speet

How can I change the chart so date is up and down and data is acro
 
I have a chart that has the date across the bottom (category axis) and the
data up the side (value axis). I want to change these. Is this possible?

Andy Pope

Hi,

It depends on what chart type you are using.
Have a look at Jon Peltier's example for a line chart.
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Cheers
Andy

speet wrote:
I have a chart that has the date across the bottom (category axis) and the
data up the side (value axis). I want to change these. Is this possible?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Holly Dunn

How can I change the chart so date is up and down and data is acro
 

?B?c3BlZXQ=?= Wrote:
I have a chart that has the date across the bottom (category axis) and
the
data up the side (value axis). I want to change these. Is this
possible?

It is possible, change from rows to columns on step 2 of chart wizard




All times are GMT +1. The time now is 06:11 AM.

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