| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automate chart X-axis/data
I am preparing a template that will be used by many of our sites to prepare a
monthly Cost of Poor Quality chart. This is a stacked bar chart that depicts the current months data plus the previous 12 months of data. Data is added every month and I want the charts X-axis will roll every month to display the current month plus the past 12 months. Any ideas how to accomplish this? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Automate chart X-axis/data
Essentially, you want to show the last 13 months of data. Adapt the ideas at
Dynamic Charts http://www.tushar-mehta.com/excel/ne...rts/index.html particularly example 2 -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "dave157" wrote: I am preparing a template that will be used by many of our sites to prepare a monthly Cost of Poor Quality chart. This is a stacked bar chart that depicts the current months data plus the previous 12 months of data. Data is added every month and I want the charts X-axis will roll every month to display the current month plus the past 12 months. Any ideas how to accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to manually switch data from x axis to y axis in line chart? | Charts and Charting in Excel | |||
| chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
| How can i set up a 3d chart with z axis data? | Charts and Charting in Excel | |||
| How do i get my data to be on the x axis of a chart? | Charts and Charting in Excel | |||
| In a 2 Y-Axis chart, how do I assign data ranges to an axis? | Charts and Charting in Excel | |||
Linear Mode
