If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 month’s data plus the previous 12 months of data. Data is added every month and I want the chart’s X-axis will roll every month to display the current month plus the past 12 months. Any ideas how to accomplish this? |
#2
|
|||
|
|||
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 month’s data plus the previous 12 months of data. Data is added every month and I want the chart’s X-axis will roll every month to display the current month plus the past 12 months. Any ideas how to accomplish this? |
Thread Tools | |
Display Modes | |
|
|